Simple report from data list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tiff - 26 Jan 2006 17:04 GMT

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 to this Message

Jim Thomlinson - 26 Jan 2006 17:19 GMT

Your description is a little thin on details, but have you looked at pivot
tables? They are used to summarize data.

Signature

HTH...

Jim Thomlinson

> 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?
[quoted text clipped - 4 lines]
>
> Thanks for any help!

Reply to this Message

Tiff - 26 Jan 2006 19:32 GMT

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!

> Your description is a little thin on details, but have you looked at pivot
> tables? They are used to summarize data.
[quoted text clipped - 7 lines]
> >
> > Thanks for any help!

Reply to this Message