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!

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!

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!