Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pajama sam
 
Posts: n/a
Default Can I create a form to run off of info saved on Excel 97?

I have alot of info stored onto an excel workbook and add to it daily. Info
keyed into this spreadsheet daily has to be handwritten onto a coversheet for
others to view. I have to fill out 30+ seperate sheets of paper with
selected info from each row added into excel each day.. Is it possible to
print this info out on a form? Or do I have to use Microsoft access for that?
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Yes, it should be possible. You would have to create an electronic
version of the cover sheet within XL. Then, in the appropriate
locations you would have cells with formulas that look up the relevant
data from the data set. Alternatively, explore Word's 'mail merge'
capability. In this case, the form would be in Word and the mail merge
piece of the operation would extract the relevant rows of data from XL
and create one copy of the Word document per row.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGFqYW1hIHNhbQ==?=" <Pajama
says...
I have alot of info stored onto an excel workbook and add to it daily. Info
keyed into this spreadsheet daily has to be handwritten onto a coversheet for
others to view. I have to fill out 30+ seperate sheets of paper with
selected info from each row added into excel each day.. Is it possible to
print this info out on a form? Or do I have to use Microsoft access for that?

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
How do you create a vendor tracking form for accounts payable pro. FLBusybody Excel Discussion (Misc queries) 0 February 24th 05 03:13 AM
How do I create a form in Excel? arethia Excel Discussion (Misc queries) 1 January 25th 05 11:46 PM
create a data entry form template in Excel 2003? david.bottomley@haltoncollege Excel Discussion (Misc queries) 0 January 19th 05 09:59 AM
Adding info onto a "permanent" form Howeey Excel Worksheet Functions 1 December 25th 04 08:12 PM
How do I create a total sheet that will pull info from all my she. JulieD Excel Worksheet Functions 2 November 12th 04 08:44 AM


All times are GMT +1. The time now is 06:12 AM.

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

About Us

"It's about Microsoft Excel"