Hi All,
I've searched everywhere and can't find the answer to my specific problem.
I have a .csv file that's created by merging 3 other .csv files. This has led to data being duplicated in this fashion (sample data):
hCR6jLG.png
What I would like to achieve is the following result:
HpBGtjU.png
As you can see I would like to merge all rows where the information in columns A-D are the same.
Is this possible with a macro? Thanks in advance for your help.
Am I correct in thinking that the ID will always be unique to that person?
!If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
If I helped do this, then please show your appreciation by awarding rep points.
<------ Button for that is over there
Yes that is correct.
Try this:
Please Login or Register to view this content.
Last edited by ARowbot; 07-30-2015 at 06:41 AM.
Thanks ARowbotI'm getting an error "Application-defined or object-defined error" (1004) on this line:
Please Login or Register to view this content.
Silly me!
Use this instead:
Please Login or Register to view this content.
Perfect! Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks