Report from data
 

I have a spreadsheet with names and other info such as weight height etc...
I want to print an information card for each of the row's data.. What is
the best way to do this. To view the row data in a card form on another
worksheet i am using the vlookup function... thanks
--
Jeff

You may want to consider creating the "information card" in MSWord and then
using excel to hold your data.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

GoBucks wrote:

I have a spreadsheet with names and other info such as weight height etc...
I want to print an information card for each of the row's data.. What is
the best way to do this. To view the row data in a card form on another
worksheet i am using the vlookup function... thanks
--
Jeff

--

Dave Peterson

Thanks Dave, it will take a little tweaking, but it will work i think.

--
Jeff


"Dave Peterson" wrote:

You may want to consider creating the "information card" in MSWord and then
using excel to hold your data.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

GoBucks wrote:

I have a spreadsheet with names and other info such as weight height etc...
I want to print an information card for each of the row's data.. What is
the best way to do this. To view the row data in a card form on another
worksheet i am using the vlookup function... thanks
--
Jeff

--

Dave Peterson