Forum Discussion
Summary Sheet with multiple different tabs with different information
I have a summary sheet I need to make. It goes through multiple sheets with different data. This is the blank Summary now, the pastel highlighted cells are the ones I need filled with data in mu...
They don't stay in the same spot. Each tab is a different flavour & some flavours have more ingredients so they may take extra rows. I need all Flavour 1 in the flavour 1 summary, flavour 2 in the flavour 2 summary, etc. but we might do 3-4 flavours a month (1 per day) & each day is a different tab. there could be up to 15-20 tabs a month.
This is a great example of how splitting things over different tabs causes issues when you want to report over your data. I would want to point you at the SUMIFS function, but that won't work across multiple tabs.
I think your best bet is to use Data, Get Data, From File, From Workbook and go from there, but that is not so simple to explain.
I think your best bet is to use Data, Get Data, From File, From Workbook and go from there, but that is not so simple to explain.
