Macro to copy current sheet to new sheet and rename with that days date in DDMMYY format

We have a formatted sheet which is missing data values that is copied each day and renamed and then that days data is copied into it. I am trying to build a macro (partially there) which:-

1] takes blank (data free) sheet and renames to the current date
2] runs the first data grab where it pulls data values from live feed sheet (connected to SQL DB) and copies values in

It will then have repeats of step 2] which runs again at other times of the day started by a macro button (already achieved - thanks 'record macro')

I am just looking at how to achieve step 1]
???

Thanks 5D

May I suggest to use record macro for step one?
Initialize record
copy an existing sheet (so the name its known)
rename it with today() date.
stop recording
look at it

Please Login or Register  to view this content.

Hi rcm

Thanks for the reply but if I am recording a macro which forms step 1 then I am manually renaming the copied sheet. I am looking for the macro to rename the sheet on a daily basis therefore if it records "me" manually entering the date then it will not automate that for me in the future.

Regards

5D

The second part is the modified macro in which the last statement renames the new sheet as the date.

Have run into problem that when using macro record and going through the 'copy sheet' process it drops all the macros in the blank template and also renames the buttons. In essence it copies the buttons but with none of the macros assigned

(also noted that this is in the wrong forum group so have asked admin to move it)