Hi. I have a form on sheet one. on the next few sheets, there is data
which has to be posted into the Form on sheet 1 and then printed one
at a time. How can this be done using a macro?

hi,
basicly it's done by selecting each sheet and printing the selected range.
This can be done on record. Toolsmacrorecord new macro.
while in record mode, perform all the actions you normally do. then close
the macro record. if your data doesn't vary each day and your routine doesn't
vary, you should be set. If you data does vary or your routine, then you can
post your recorded code and someone should be able to make it generic. if you
repost, be sure to explain any variations you may have.

Regards
FSt1

"tc" wrote:

Hi. I have a form on sheet one. on the next few sheets, there is data
which has to be posted into the Form on sheet 1 and then printed one
at a time. How can this be done using a macro?