Create Excel Form with Excel data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel speadsheet of data that I would like to print out a seperate form of each record (line item). I am familar with Access's ability, though I thought I can accomplish the same from within Excel since Excel was actually created as a database application some years ago.
 
You could use a macro to loop through the items in a list, and print
each one on a separate form.

Or, if there are no complex calculations, you could use Word's Mail
Merge feature to print the forms, with the Excel file as the data source.
 
You must log in or register to reply here.

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

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Dynamic Excel data into locked Word form 0
Excel Query setup 0
How do I transfer data from one worksheet to another? (Excel 2003) 0
CSV->Excel Data Problem 1
Creating Forms in Excel 2
Excel Export Filtered Form Data To Excel 0

Back
Top