I have a workbook that has a new worksheet created every month.
Without loops, I can copy the data specifically.
I want a loop for the sheets such that when a new sheet is created, I can assign a button to a macro which copies the data from the previous sheet.
For example if sheet 7 is created, i want to copy the values from sheet 6 and paste.
Also if sheet 8 is created, i want to copy the values from sheet 7 and paste.
please can anyone help. thank you