I have a series of sheets with duplicate structure. I want to choose which sheets to sum into a total worksheet. The total sheet also has the same structure. Since the worksheets to add together change, I cannot simply do a sum across sheets. Furthermore there are about 50 formulas that would have to sum.
Ideally I would like to creat a list of sheets and choose the ones to add. Caould someone help me with the macro?
By: Tom Banks