Invoice directly from EXCEL?

[vv]

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.

 

[Bernie Deitrick]

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