Hi, Im trying to make a workbook for work but Im not too familiar with Excel.
What im trying to do is have a macro button to create a new worksheet with the same table thats on the previous worksheet but automatically change the sheet name to the ascending number (e.g 1, 2, 3) and 1 of the cells needs to automatically increase each time a new sheet is made.
Any ideas how to do this?
Sounds like a fairly straight-forward bit of vba to do something like
workbork(n).copy
workbook(n+1).rename
workbook(n+1)!$A$1 = workbook(n+1)!$A$1 + 1
or something like that.