I have 2 Excel sheets in a workbook.
One sheet has a list of dates down column A.
The other sheet has ONE row of data I refresh and update once each day. It also has THE CURRENT DATE in column A "=today()".

When I refresh the row of data each day, I also want it to automatically copy/paste that row of data into the today's date row of the other sheet.
That way, I will be able to create a history log of the data for each day.

Is this possible?