Hello everyone,
I have attached a worksheet showing what I'm trying to do.
Basically I need to get/concatenate all the text for all the Name 1's into one cell and the same for Name 2's etc. I have a list of over 3,000 names so i'll just want to be able to drag a formula down.
I started experimenting with transpose but didn't really know what I was doing. Can anyone help?
Last edited by D_N_L; 10-23-2012 at 06:35 AM.
Try this code
Put it in a standard module.
Please Login or Register to view this content.
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]
Thank you Arlette!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks