Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default Copying Form Fields to Log

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Fields Anna Excel Discussion (Misc queries) 1 November 21st 06 12:42 AM
Form Fields mcaalcorn Excel Discussion (Misc queries) 0 March 3rd 06 11:06 AM
On Enter: next row copying certain fields from previous row Lava Excel Programming 18 October 25th 05 10:34 PM
Cycling through form fields Azza Excel Programming 2 October 12th 04 10:44 PM


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"