Filling up Forms

  • Thread starter Thread starter tc
  • Start date Start date
T

tc

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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
application.activesheet, should I use it? 3
Macro to Combine Data from Multiple Sheets with Cell References 4
Save record Into master sheet! 1
Auto Fill Columns A and B with varying ranges 6
Combining Multilple Worksheets Into One 6
Macro to Compile Data from Different Sheets 2
Loop & Print 17

Back
Top