I have a worksheet that I use to print out name badges when people meet
certain criteria. I need a formula that will remove the names from the cells
after I print out the badges. I was thinking if I put an x by the names (the
names are in two different cells first and last names) that the x would have
a formula that would move that name to a cell that is titled Completed
badges. Any suggestions? I can attach the worksheet if you need me to.. but
someone will have to tell me how.

Jennifer wrote...
I have a worksheet that I use to print out name badges when people meet
certain criteria. *I need a formula that will remove the names from the cells
after I print out the badges. *I was thinking if I put an x by the names (the
names are in two different cells first and last names) that the x would have
a formula that would move that name to a cell that is titled Completed
badges. *Any suggestions? *I can attach the worksheet if you need me to.. but
someone will have to tell me how.

Why are you trying to do this with Excel rather than with Word using a
mailing list?

Harlan,
The reason I am using Excel is because this worksheet has to create the name
list for the badges. I have three criteria that has to be met before the
badges can be printed. So you all here helped me with those formulas and
they work great. Now I just want to remove the name from the list when i put
a check or X in the box saying that a badge has been printed. My worksheet
is layed out as follows. A has the first name, B has the Last name. C, D &
E are the three items that need to be completed, so for example if the person
had a TB test, completed their code of conduct test and their Megans law
test. If all those fields had something in them then that persons name
showed up in fields G & H. Now I just wanted to be able to put an X next to
H (in I) and have their names removed from G & H and show up in K which is
labeled Badges already printed. Hope that is clear.
Thanks for your help.

"Harlan Grove" wrote:

Jennifer wrote...
I have a worksheet that I use to print out name badges when people meet
certain criteria. I need a formula that will remove the names from the cells
after I print out the badges. I was thinking if I put an x by the names (the
names are in two different cells first and last names) that the x would have
a formula that would move that name to a cell that is titled Completed
badges. Any suggestions? I can attach the worksheet if you need me to.. but
someone will have to tell me how.

Why are you trying to do this with Excel rather than with Word using a
mailing list?

Harlan,
The reason I am using Excel is because this worksheet has to create the name
list for the badges. I have three criteria that has to be met before the
badges can be printed. So you all here helped me with those formulas and
they work great. Now I just want to remove the name from the list when i put
a check or X in the box saying that a badge has been printed. My worksheet
is layed out as follows. A has the first name, B has the Last name. C, D &
E are the three items that need to be completed, so for example if the person
had a TB test, completed their code of conduct test and their Megans law
test. If all those fields had something in them then that persons name
showed up in fields G & H. Now I just wanted to be able to put an X next to
H (in I) and have their names removed from G & H and show up in K which is
labeled Badges already printed. Hope that is clear.
Thanks for your help.


"Harlan Grove" wrote:

Jennifer wrote...
I have a worksheet that I use to print out name badges when people meet
certain criteria. I need a formula that will remove the names from the cells
after I print out the badges. I was thinking if I put an x by the names (the
names are in two different cells first and last names) that the x would have
a formula that would move that name to a cell that is titled Completed
badges. Any suggestions? I can attach the worksheet if you need me to.. but
someone will have to tell me how.

Why are you trying to do this with Excel rather than with Word using a
mailing list?