Master data to be updated from import sheet.

[SvenOpolcer]

Hello everybody,

I have a quick question. I have a main master file which is full of data and each row has a unique id in cell A. Master Data should ideally be updated with export from our share point. I have put in a macro to always import an export data from the system into a new sheet, however I would need a macro to compare everything in column A in "Master data" to column A in "Current report" and if there are any values (unique IDs) in "Current report" that are not already on "Master data", that it pastes those as values in first available row in column A of "Master file". I hope my question makes sense!

[Trebor76]

Hi SvenOpolcer,

Welcome to the forum!!

Let me know how this goes:

Please Login or Register  to view this content.

Regards,

Robert

[SvenOpolcer]

Hi Robert,

Thank you for such a quick answer, Unfortunately i get a error which says "no cells were found" on this line of code((wsCopyFrom.Cells(2, 1), wsCopyFrom.Cells(lngLastRow, 1)).SpecialCells(xlCellTypeVisible).Copy Destination:=wsCopyTo.Range("A" & Rows.Count).End(xlUp).Offset(1, 0) ). When I run the macro again, it seems to copy over 2 lines, one blank one, and one which is a heading. I probably should of mentioned master data starts in row 5 (due to various headings), and in current report the entries start in row 2.

[Trebor76]

Not sure as it works for me (refer attached)