Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

Create a printable FORM

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michell Major - 14 Sep 2007 11:44 GMT
I need to create a FORM that prints data rather than enters data - odd I
know.  The forms are certificates required by regulation.  So, data is
entered into a table and then merged into a FORM that is printed on the print
command.

I have created an Excel template but this may work better as a Word and
Excel merge?
Bernie Deitrick - 14 Sep 2007 14:24 GMT
Michell,

Here's the general technique.

Let's say that your data is on sheet "Data" in columns A to Z, and you have a sheet "Print Form"
that is nicely formatted, with spaces for your desired data. Let's also say that your data table has
unique identifiers in column A, which we'll call the data key.

On the print form, use one cell as the index cell, where you will enter the values from the data key
column of your data table.  Then for all the fields that your want to display, use VLOOKUP formulas
that extract the relevant data from the data table, based on that key value.

For example, enter "Michell" in cell A1 of "Print Form" and in cell A2, use the formula

=VLOOKUP(A1, Data!$A1:$Z1000,4,False)

to pull the data from column D of the data table where the key value in column A = Michell.

And so on, and so on.

HTH,
Bernie
MS Excel MVP

>I need to create a FORM that prints data rather than enters data - odd I
> know.  The forms are certificates required by regulation.  So, data is
[quoted text clipped - 3 lines]
> I have created an Excel template but this may work better as a Word and
> Excel merge?
Michell Major - 14 Sep 2007 15:14 GMT
Bernie.  Thanks, I'll give it a go over the weekend.  Dan

> Michell,
>
[quoted text clipped - 27 lines]
> > I have created an Excel template but this may work better as a Word and
> > Excel merge?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.