LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 49
Default Excel form file

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

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 Desc Amt
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
 
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
How do I embed a .lnk file in an Excel form? SIMPSBA Excel Discussion (Misc queries) 1 May 3rd 09 03:36 PM
Call user form from ThisWorkbook; close file if form closed XP Excel Programming 2 July 20th 07 07:04 PM
File in 2007 form - need to get back to 2003 form... RHM Excel Discussion (Misc queries) 2 May 7th 07 05:38 AM
Excel Form File Errors hartleydc Excel Discussion (Misc queries) 0 September 29th 05 11:20 PM
Excel-Form to file.txt Hennie[_2_] Excel Programming 1 June 25th 05 11:10 AM


All times are GMT +1. The time now is 05:46 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"