I have a workbook that has 13 worksheets with tab names like "7-4 13186" and "7-11 13193" that represent weeks in a quarter. The 14th sheet would be a summation of the same cell from each worksheet. For example, on the totals sheet:
These are the actual names of the worksheets for the 3rd quarter. My problem is, this code will only work with this one quarters data. I use a macro to create new tabs for each quarter, so the 4rth quarter will begin with "10-3 13277", and next is "10-10 13284".Please Login or Register to view this content.
How would I use a variable for the names of the tabs so I could use the macro to fill in each total sheet?
If it helps, I have a list of the names in a worksheet titled "Drop Down Lists" cells C39:C51; this is the source where the sheets are originally named. In addition, there are quite a few sheets total up to this point. I'll try to attach a screen shot showing the sheet listing.
Also, this is the code I'm using:
Any and all help is GREATLY appreciated!!Please Login or Register to view this content.
Thanks,
Mike - Accountant II
p.s., I'll be changing jobs on Friday, so I'm kind of in a bit of a hurry to complete this by close of business Thursday 10-11-2012 - Thanks again!
Bookmarks