Hi anybody,



EXCEL. Is it possible to merge data from LIST1 to invoice on LIST2? Every
row in LIST1, should generate and print new invoice. I only know how to do
it by Word. Many Thanks, Vladi.

Yes.

You need to either tie the values on List2 to a key value of one cell using VLOOKUP formulas, or use
a macro to step through data on LIST1 and place it on sheet LIST2 prior to printing (once for each
row on LIST1).

For example:

For Each myCell In Worksheets("LIST1").Range("A2:A100")
If myCell.Value < "" Then
Worksheets("LIST2).Range("B1").Value = myCell(1,1).Value
Worksheets("LIST2).Range("H12").Value = myCell(1,2).Value
Worksheets("LIST2).Range("G13").Value = myCell(1,3).Value
Worksheets("LIST2).Range("D4").Value = myCell(1,4).Value
Worksheets("LIST2).Range("C15").Value = myCell(1,5).Value
Worksheets("LIST2).PrintOut
End If
Next myCell

HTH,
Bernie
MS Excel MVP


"vv" <microsoft.public.cs.desktop wrote in message ...
Hi anybody,



EXCEL. Is it possible to merge data from LIST1 to invoice on LIST2? Every row in LIST1, should
generate and print new invoice. I only know how to do it by Word. Many Thanks, Vladi.