Choose worksheets to sum

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?

 

Thanks

 

Tom

By: Tom Banks

Leave a Reply

Your email address will not be published. Required fields are marked *