Create a new worksheet then copy data from mainsheet

[city]

Hi All,

Unfortunately, I need help again. Can someone please help me on how to create a macro that will create a new worksheet then copy columns AA:AT in the newly created worksheet.

So far I have a macro that creates a new worksheet based on the day of the month.
The copy codes that I have is not what I am actually looking for because what I need is to copy columns AA:AT to cell B6in the newly created worksheet



Please see attached file.

create new sheet and copy data from old.xlsm

[john55]

just try it as an option!

Please Login or Register  to view this content.

[city]

Nice code! Thanks John. Your code is much simpler and much more accurate. Thank you so much!

[john55]

you're welcome!