I need help a.s.a.p. please.
I would like to be able to have a macro, working automatically, so that when you add next entry in the table it creates a copy of MASTER sheet and name it as the cell value.
I.e. If I add following data in the table:
Argentinos Juniors (A2)
Volga Novgorod (A3)
Real Salt Lake (A4)
it (macro) automatically creates 3 sheets (copies of MASTER sheet), name them as the cell values (so Argentinos Juniors, Volga Novgorod and Real Salt Lake) and put it's (sheet) name in cell B1 of this sheet.
Also in SUMMARY sheet table is filled in automatically with cells in columns B i C (formulas as in above row).
I need also something to protect already created inputs (and sheets) so if somebody is altering (or deleting) any record in the table macro is asking if the sheet name needs to be changed or sheet needs to be deleted and deleting it (or changing name).
For duplicate input (so if someone will input for example Argentinos Juniors again) it needs to create sheet named Argentinos Juniors 2, Argentinos Juniors 3 etc... and changed input in column A so it will be also Argentinos Juniors 2, Argentinos Juniors 3 etc.
Thanks for any support!
I have attached sample workbook so it will be easier to understand what I need... hopefully.
Also posted on bigresource.com:
http://excel.bigresource.com/Track/excel-ej1s98DX/
Bookmarks