Jul 01 2019 10:51 PM
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 formula to find and return the relevant data from each tab. I believe it is a combination of Index and match across the tabs.
Attached is an example.
Appreciate any help.
Kind regards,
Jul 02 2019 01:14 AM
Jul 02 2019 02:10 AM
Jul 02 2019 04:04 AM
@calof1 Here are the steps:
Jul 02 2019 05:56 PM
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.
Jul 03 2019 02:18 AM