Forum Discussion
Help to find relevant data across multiple tabs of data. I think it is a index, match 3D formula
Hi Everyone, I have a spreadsheet that has large number of tabs which are set up identically, there is just one tab for each product. Then lastly there is a summary tab. I want help with a formul...
Thank you very much for the step by step instructions. I have been able to create a pivot table however it is slightly different to yours. For the "Statistics based on current Year" is this a named range created in the query? My attempt thus far is showing data from my first tabs of data, which i do not need to include.
I have attached what i am working on, the pivot table is located on row 125 down of the "Summary of Stocks" tab. Can you please see if you can tell what i need to amend in the query?
Thank you again for your support, much appreciated.
Looks like you at least did not filter the calculated column containing the length of the worksheet names to 3 characters. Also you didn't remove the unneeded columns. The steps are there in my instructions :-)