| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple report from data list
I would like to print a simple summary report (on one tab) for each record in
a list of 400 records (on a separate tab)... Any relatively simple ideas? The report use a vlookup to get the data for the record, but I don't know how to update the vlookup formula with the next record... until there are no more. Thanks for any help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Simple report from data list
Your description is a little thin on details, but have you looked at pivot
tables? They are used to summarize data. -- HTH... Jim Thomlinson "Tiff" wrote: I would like to print a simple summary report (on one tab) for each record in a list of 400 records (on a separate tab)... Any relatively simple ideas? The report use a vlookup to get the data for the record, but I don't know how to update the vlookup formula with the next record... until there are no more. Thanks for any help! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Simple report from data list
It is so simple. I have a list of 400 records in the first tab with sales
data for 400 reps. I just want to repetitiously print a little summary report (which is on another tab) which gets data for each rep and applies a few calculations to it. I dont need to create a separate report for each ....just create a report for the first record, print it, and then refresh the data for the second record, print it, and so on until a page is printed for each rep... I hope that is clear... Thanks for the help! "Jim Thomlinson" wrote: Your description is a little thin on details, but have you looked at pivot tables? They are used to summarize data. -- HTH... Jim Thomlinson "Tiff" wrote: I would like to print a simple summary report (on one tab) for each record in a list of 400 records (on a separate tab)... Any relatively simple ideas? The report use a vlookup to get the data for the record, but I don't know how to update the vlookup formula with the next record... until there are no more. Thanks for any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change a crostab report to a simple columnar format | Excel Discussion (Misc queries) | |||
| Non VB (simple VB) Hyperlink Data Validation List | Excel Discussion (Misc queries) | |||
| Simple Excel report | Excel Discussion (Misc queries) | |||
| Need simple good expense report in excel | Excel Discussion (Misc queries) | |||
| filtered sorted packing list report from data table | Excel Discussion (Misc queries) | |||
Hybrid Mode
