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!