Macros From Rows to Excel Files

Closed
emeva Posts 1 Registration date Saturday December 13, 2014 Status Member Last seen December 13, 2014 - Dec 13, 2014 at 03:25 PM
Hello Fellas
I have a workbook in which I have a list of Clients with details in the columns (name A, phone B, direction C, ZP D, etc)
and I need to fill a form for each client but those are 2000+!

and I am no expert on this subject. could anyone help me on this?

Example:

Contact List.xls
A B C D
1 Will Hudson 915 585 2525 Main Street 825 Contact Lenses
2 Marry Ann 958 5568525 Double Party 313 Mops

To:

Will Hudson.xls
A B
1 Name: Will Hudson
2 Phone: 915 585 25 25
3 Adress: Main Street 825
4 Product: Contact Lenses

And So on with all the contacts.

Thanks in advance for your help!