Can anybody please help me create a Macro that takes adds G1 from all the Sheets Except the one on which the macro will be written.
For instance I have Template, template(2), Template (3)......... and i need to add the values from G1 on all of them and put that total on G1 of a mastersheet.
The reason i need a Macro is because. The number of sheets present also depend on an input cell on this master sheet, which in turn invokes the makesheet Macro.
So if A4 on the mastersheet:4, there will be 4 copies of an existing template and i will put some inputs into these 4 templates and then on the master sheet i need a macro that adds all these sheets.
Also, I need for it to ignore 1 sheet, which is a Anuity table that is being referenced to look up values.
I hope i was clear. Any guide would be helpful.
Thank you,
Bookmarks