Take info on spreadsheet and turn it in a report

A

andreah

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?
 
B

Bernie Deitrick

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
 
Top