merging multiple worksheets with varying amount of rows to a master & removing dupes

[spj3745]

I need help merging the files from multiple worksheets (new worksheet will be added monthly) to a master sheet. Then need to remove duplicates. Have never used macros but looking to learn. Any help appreciated. Example attached

[AB33]

You do not specifay in which column are the duplicate values. Which rows/columns do you wish to copy?

[oeldere]

See the attached file.

Run the macro integratie_oeldere

[spj3745]

All columns will be consistent. Rows 1-9 will also be consistent and are considered the headers. Data needs to be sorted by Column A beginning with Row 10 and then by Column M again beginning with Row 10

[spj3745]

apologies, remove duplicates beginning with row 10 and proceeding from there

[AB33]

spj,
It would be easier to remove duplicates from Master sheet (once all the data are merged in to it), instead of from individual sheets. If this what you wanted, I can see duplicates in Column A and I suspect you wish to remove the entire row if A is duplicate. Is this right?

[spj3745]

yes, that is correct. I do not want remove anything from the source sheets, only duplicates from the master sheet from Row 10 down.

[AB33]

Spj,
All cells in column A are duplicates, so If I were to delete them, you left with nothing. I think it would be good idea, if we take one step at a time. This codes, colsolidates all data in to master, including duplicates. Run it and see which part of the data needs to be changed.

Please Login or Register  to view this content.

[spj3745]

Looks good. Now I would want to delete duplicate values based on Column C

[oeldere]

Please Login or Register  to view this content.

SBA is duplicated => you want both rows to be deleted?

[spj3745]

no, the row show only be deleted if there is a duplicate value in Column C "Customer"

[oeldere]

Please Login or Register  to view this content.

So both rows hav to be deleted?

[spj3745]

no, only the duplicate. I need one record to remain when there are duplicates.

[AB33]

Please Login or Register  to view this content.