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.
see your post under general questions

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?

for each cell in worksheets("Data").Range("A1:A20")
With Worksheets("sheet1")
.Range("B9").Value = cell.value
.Printout
end with
Next

You would need to have lookup type formulas (perhaps vlookup) in the other
cells on sheet1 to fetch the values related to the value placed in cell B9
(in the example).

=if(b9="","",vlooku(B9,Data!A:F,3,False))

--
Regards,
Tom Ogilvy


"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?