Using a macro to copy and past data for a daily sales report

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.

I attached a sample of the excel macro I started.

Perhaps something like this could be useful?

To test run macro "FindMatch"

First of all in your uploaded file you had "Oranges" twice in "Profits" sheet but only once in the "Daily_RawData" so I modified the "Profits" sheet.

The macro starts by activating "Daily_RawData", it then starts checking all values in range B3:Y3 of "Profits" and compare that with the date value in cell L3 of the
"Daily_RawData" and when a match is found the address for the cell that matches is "stored" as the string cAdd and further checking of cells is stopped with the "GoTo" command.

The range B7:H7 of "Daily_RawData" is copied and pasted to the matching date in "Profits" with an offset of 2 rows and the values are transposed. Then the % profit is copied this time with an offset of 1 row.

In your uploaded file all calculated % profits were the same and you "Profits" sheet har only on row for this that I take as this will always be so in the future or?

If not so macro can be modified of course.

Alf