Hi Team,
I am trying to copy and paste data from a daily report into a created dashboard. The data is copied daily and each day I put the new data in the correct date field. I was able to get the macro to repeat, but it keeps putting it in the same row. I tried to used the relative macro, but I don't know how to make the data move to the next day. This process must be repeat each day until the end of the month.
The raw data file is a new file everyday.
How do I have the macro copy the file to the next day without over typing the prior days info.
Thanks.
It would be cool If I could create a button that says "Start Report-10/1" that will allow me to change the date so I know what date I'm copying. I'm open to suggestion as I'm still a novice at this.
File has been attached.
THanks.
Bookmarks