Hi,
I had the macro below which was working but now isn’t. The layout of the data has changed but I believe this should work:
The macro would copy the “Model” sheet to a new page each time and for each new sheet it would place the sheet reference in cell C4.![]()
Please Login or Register to view this content.
So, as there are 5 customers on the “Data” sheet it would create 5 new sheets entitled “1”,”2”,”3”,”4”,”5” all containing the same information as on the “model” template.
Can anyone see what is wrong?
I have uploaded an example...
Bookmarks