#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bethany L
 
Posts: n/a
Default Data Entry Form


I have a worksheet form that has a vendor name and then several rows of
information. I would like to send the data to a spreadsheet list. I would
like to send several of these filled out forms to the same list throughout
the week. How do I do this? I want the vendor name listed with each entry.
Does this make any sense? Here is an example of the list that would come
from only 2 forms, one for each vendor...

Vendor ABC $40.00 52552363 1/20/06
Vendor ABC $55.00 22134663 1/22/06
Vendor XYZ $89.24 11124363 1/25/06

I was told that excel can import content from several files to one list but
I have not been able to figure it out yet.

Basically I am trying to enter payment information onto a form, print the
form, save the form and have the data entered on the form sent to a list to
be printed at the end of the week. (a submit button would make my day!) I
think I may bo making this all too complicated.

Any help would be greatly appreciated!!


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
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
a data entry form with combo box xcao Excel Discussion (Misc queries) 4 June 25th 05 05:37 AM
How do you create a selection box for data entry within excel Ligia Magnus Excel Discussion (Misc queries) 1 May 25th 05 08:10 PM
format cell from data input to output form Brad Stevenson Excel Worksheet Functions 2 May 19th 05 06:04 PM


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