macro to copy and paste data from one workbook (which has 1 row of updated data) to an existing workbook using dates and data (which has a all the dat

[hongy1978]

Hi,

just seeing if anyone can help.

so, i have the updated data in one row in an excel spreadsheet, dates start on row A6, Data to be copied is in cells C6:AV6. Dates is in Cell A6. The data and dates will get updated every workday. the cells range is the same

i want the macro to copy the updated data in 1st spreadsheet into another spreadsheet which has all historical data.

data range is the same in 2nd spreadsheet.

the idea that the updated spreadsheet 1 will find the matching date in spreadsheet 2 and paste the new data, so that the full set of data will always be maintained.