reference multiple tabs
I have about 150 tabs, each tab representing 1 product. Each tab contains
monthly volume. I want to create a master summary sheet that has the names of all the products in one column and then pulls the monthly data from their indivdual tabs. For eg: Each product tab looks like: A1234 Jan Feb Mar Apr May Jun..... I would like the summary sheet to look like: Jan Feb Mar Apr May Jun A1234 A2345 A3456 Any help on how I can accomplish this, would be great!! Thanks |
All times are GMT +1. The time now is 11:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com