Take info on spreadsheet and turn it in a report
 

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

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