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
Bookmarks