andreah,

Set up your report printing to extract the data from your datatable using VLOOKUP formulas, all
keyed to one cell on the report sheet (let's say A1). Then use a macro like:

Sub DoReports()
Dim myCell As Range

For Each myCell In Worksheets("Data").Range("A2:A2000")
Worksheets("Report").Range("A1").Value = myCell.Value
Application.calculatefull
Worksheets("Report").Printout
Next myCell

End Sub

HTH,
Bernie
MS Excel MVP


"andreah" wrote in message
...

I am wondering if someone can help me. No one in my office including me
now if this is possible but..... I am needing to take information from
a spreadsheet with all of our customers and turn it into a report (like
an invoice) for each customer. Is that possible?


--
andreah
------------------------------------------------------------------------
andreah's Profile: http://www.excelforum.com/member.php...o&userid=26635
View this thread: http://www.excelforum.com/showthread...hreadid=399103