First off, let me thank the two people who answered my previous questions. They were right on. What a great resource this is.
We are trying to wrap up the mailing for our charity event in California and have one final issue with a set of names here that needs to be solved right away.
There are two worksheets with the following: names, addresses and phone numbers. In both worksheets they reside in column "A".
Examples follow:
John Doe (The name is always in bold)
123 Main St Anytown CA 94111
415-555-1212
Jane Smith (Bold)
456 Main St Anytown CA 94111
415-555-1212
This goes on and on and on. It seems that it is possible to write some code that could search the "A" column starting from the beginning and key on the BOLD name, once it finds a bold name it can then take that name and place it for example "B1", take the address which is always right below it and put it in "C1" and the phone into "D1". It then moves onto the next BOLD name and inserts name into "B2", "C2" and "D2" . going down until it has slotted all the "A" column names to the "B", "C" and "D" columns.
I can then take the zip codes out and put them in another column (already know how to do this thanks to you guys!)
If anyone out there can help with this code, it would be very much appreciated.
We are trying to wrap up the mailing for our charity event in California and have one final issue with a set of names here that needs to be solved right away.
There are two worksheets with the following: names, addresses and phone numbers. In both worksheets they reside in column "A".
Examples follow:
John Doe (The name is always in bold)
123 Main St Anytown CA 94111
415-555-1212
Jane Smith (Bold)
456 Main St Anytown CA 94111
415-555-1212
This goes on and on and on. It seems that it is possible to write some code that could search the "A" column starting from the beginning and key on the BOLD name, once it finds a bold name it can then take that name and place it for example "B1", take the address which is always right below it and put it in "C1" and the phone into "D1". It then moves onto the next BOLD name and inserts name into "B2", "C2" and "D2" . going down until it has slotted all the "A" column names to the "B", "C" and "D" columns.
I can then take the zip codes out and put them in another column (already know how to do this thanks to you guys!)
If anyone out there can help with this code, it would be very much appreciated.