Hello,
I have a list of data with 6000 names and various pieces of information about that individual.
John Smith
Company A
555-555-1234
555-555-2000
[email protected]
MikeJones
CompanyB
555-123-4567
[email protected]
My goal here is to take the above information and put it into table format. The issue that I'm having is that:
1) I'm a novice to macros
2) My amount of fields for a given individual isn't always the same. In the above example John Smith has 5 fields and Mike Jones has 4 fields. This results in a phone number being the 4th piece of information for John Smith and an email address for Mike Jones.
Thanks in advance for the help!!
How do I go about making a macro that copies the indivuals information into a table where all fields are under the appropriate table column?
Bookmarks