I screwed up and asked for help on someone elses similar question so I am reposting this as my own thread.
I have a list of companies and employees, if a company has more than 1 employee listed, I need to combine all instances of the employees into 1 row per company separated by a comma. I've looked through some of the examples posted, but my macro and vb skills are terribly rusty.
Can someone please help?
OLD FILE: Sample.xlsx
NEW FILE: Sample.xlsx
Last edited by NotAvg1; 03-04-2013 at 06:06 PM.
Can you upload a wb that shows the data before then on another sheet show what the results would look like
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Try the attached
New file attached to original post. The example tab is after the data has been combined into one row (highlighted cell), the other tab is before doing anything to it.
Every thing the same, and want to merge column G of sheet 2. Please confirm.
Do you also want the result on the same sheet, or different sheet?
Please Login or Register to view this content.
Last edited by AB33; 03-04-2013 at 06:25 PM.
Same sheet
Please see amended code above
Thank you everyone for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks