Macro to compare columns and copy rows.

My last post just timed out so I lost all my notes... Trying again...

I'm trying to create a macro to scrub new data and update my records for a rolling 30 day dashboard and other charts that feed off the main dataset...

Example file attached. I need to scan the 'New' worksheet tab, Column A [Record] against the 'Old' worksheet tab, also Column A [Record]. If a match is found then copy the row of "New" data over the row of "Old" data. If a match is not found append the "New" row to the end of the "Old" sheet / table.

I also need code to then delete rows from the 'Old' sheet that are 30 days or older than today.

Please let me know if there is any additional information I can provide, sorry my last post timed out and I lost all the extras I had included.

Thank you,
Jason.