VBA to match value in column, offset by 1 and then copy all rows to end

Hi,

I currently have the below macro that will copy data from one sheet to another,

At the moment the below code will copy all cells from A2:DT in workbook 2 and paste at A2 in workbook 1. It the deletes all data in workbook 2 ready for new data to be inputted.

Please Login or Register  to view this content.

Due to circumstances I am no longer able to delete data in workbook 2 however if I were to continue as is I would end up with duplicates in workbook 1.

All rows are assigned a specific value increase from 1 to infinity that is populated in column A and refered to as Sales ID

I have a cell located in workbook 1 that has a max formula that returns the last posted Sales ID (Currently a 4879 and located at Cell M3 of sheet 4)

Essentially what I need to do is have the macro refer to this cell, match the cell in Workbook 2 and then copy from the row below to the last row.

I think I need something along the lines of the below to reference the value that I want to match however I cannot work out how to then search through column A in workbook 2 and then only copy rows below

Please Login or Register  to view this content.

If there is somthing simple I am missing please let me know!

Thanks

Awesome, that's worked perfectly!