I currently receive a report every week on maintenance costs. Each week a new tab is made with the total costs for that week. I would like to make separate sheet that takes the weekly total every week and adds it to the data list for graphing.
I am assuming there are 2 parts to this. I would assume part one would be pull data from the B2 cell on each sheet. Then part 2 would be to graph the data. However, is there a way to automatically detect the amount of tabs and pull from them so I don't have to bother getting data each time a new tab is made?
Thanks in advance for any help!
Danny
I am assuming there are 2 parts to this. I would assume part one would be pull data from the B2 cell on each sheet. Then part 2 would be to graph the data. However, is there a way to automatically detect the amount of tabs and pull from them so I don't have to bother getting data each time a new tab is made?
Thanks in advance for any help!
Danny
