Copying Form Fields to Log

S

snax500

I have an Excel form file with 10 fields that I send to different
customers to complete. I can't link the cells because I am sending
them to outside companies.I would like to have a log that summerizes
all of my received files.

for example,
my form would look like this...

Name: Joe Smith Company: ABC Co
Address: 123 Oak
Description: Red, Green, Large
Amount: 10.50

my log file would look like this...

Name Company Address
Description Amount
Joe Smith ABC Co 123 Oak Red,
Green, Large 10.50
next form etc....

What would be the best way to write a mcaro to do this.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top