You say that you have the capability to print only one card at a time. Do
you want to be able to print all the cards at one time? Assuming that you
want to print only a specific card (name) at a time, I would suggest a small
macro. The macro would operate on the active row whenever a button is
clicked. Your sheet would have a button at the top labeled maybe "Print
This Card". You would click on any cell in the row you want to print, and
the macro will transfer all the necessary data to the template and print it.
You could expand this to print all the cards at once simply by adding a
second button, labeled maybe "Print All Cards". Click on that button and
all the cards would print. Does this sound like what you want? If so,
provide the layout of the template card. That is, the name goes into this
cell, the card number into that cell, the name into the other cell, etc.
HTH Otto

"sbaby" wrote in message
...
I have built a Excell Work book to keep track of our Fire Fighter
membership,
Basicly it goes like this, Page 1 line 2 A =Card #, Line 2 B = Name, Line
2F
= Fire Fighter, Then line 3 would be the next Member and so on. I made
card
Template on Page 3 and I want to place a button in Page 1 Line 2 H to
place
the Information in the template on page 3 " the info from the line 2 I was
mentioning 2 A, B, And F.
I have been able to Put multiple text boxes in the Template and using the
=
it will place the info from the lines I want where I want it. I am having
trouble getting the button , and Also getting it to do this for multiple
members.
I only have the capabilty to Print 1 card at a time, so I was tring to
place
a button at the end of each members info so It will place that members
info
into the card so I can print the card that I need.