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
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
You do not specifay in which column are the duplicate values. Which rows/columns do you wish to copy?
See the attached file.
Run the macro integratie_oeldere
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
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
apologies, remove duplicates beginning with row 10 and proceeding from there
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?
yes, that is correct. I do not want remove anything from the source sheets, only duplicates from the master sheet from Row 10 down.
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.
Looks good. Now I would want to delete duplicate values based on Column C
SBA is duplicated => you want both rows to be deleted?Please Login or Register to view this content.
no, the row show only be deleted if there is a duplicate value in Column C "Customer"
So both rows hav to be deleted?Please Login or Register to view this content.
no, only the duplicate. I need one record to remain when there are duplicates.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks