Copying Cells onto another worksheet

[Mark Strohmeyer]

My subject doesn't really fit my question. I know how to
copy cells.
I would like to know how to copy from a list of names in
one worksheet, an individual name at a time onto an
attendance sheet in another worksheet.
What I would like to do is print an attendance sheet and
have it automatically print one per name from the list on
the other worksheet.
Can this be done at all?

 

[Dave Peterson]

My bet is you have headers and other columns that need to be printed.

An alternative to copy|paste|print would be to apply Data|Filter|Autofilter,
then show the one you want, print it and do the next.