Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn off automatic date function in XL? | Excel Worksheet Functions | |||
Application to turn a table layout webpage back into a spreadsheet? | Excel Discussion (Misc queries) | |||
How do i turn the spreadsheet into a formula page? | New Users to Excel | |||
how to turn off email header with excel workbook | Excel Discussion (Misc queries) | |||
Suggestions requested for vacation planning Excel spreadsheet | Excel Discussion (Misc queries) |