I'm trying to develop a macro that does the following:
1) Copies a hidden tab named Template to the workbook
2) Goes back to the Main tab
3) Inserts a line on this main tab
4) Adds a formula that is =+IF('Template (xx)'!$E$14="", "", 'Template (xx)'!$E$14) to cell C9 also on the "Main" tab
Note: xx is the template tab number (ie; Template (2))
And then every time this macro is run, it has to keep changing the xx value within the formula to the new template tab name (ie; Template (3), Template (4), etc).
I've tried doing it in different ways but I just can't seem to have the macro add in between the parathesis every time it gets run.
I know it must be hard to understand as I might not have made myself clear, but let me know and I'll try harder...
But either way, thanks for looking at this post and trying to help...
Nacho
Bookmarks