Hello,
Can someone help me?
I must prepare the file (see attachment)
Sheet 'source' is a data and sheet '2' is a result. I must connect some cells with <enter> in the end of line. I searched the topics but i don't find any results like this problem. sample.xlsx
So duplicate rows should be deleted (1 out of 2 retained) and the non dups should be merged for the same numer?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yeap, I must get only 1 row with key (column A and B). The columns D:G should be connected with <enter> at the end of line. If the text in two of three cells is the same, it should be merge only 1 (or 2) and 3. I hope I explained that well
Do you mean the enter key or <enter>?
sorry, i mean enter key
Any idea?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks