Thanks Gord
In answer to your question what I have at present is the following:
worksheetShopping Centre
Column A B C
D
Client Name Price Paid
Date of sign up
Joe Bloggs $150 Y
25/6/07

Of course there are many worksheets with lots of clients and lots of other
information and some have paid and some haven't
What I would like to do is to create a summary report that will let me know
at a glance what is happening

Regards
John D

"Gord Dibben" wrote:

Depending upon your worksheet layout, you could probably use
DataFilterAutofilter to pull data.

Then build your report on that or copy to another sheet and build your report
there.

Many ways to do the job but not enough info to give a "best" solution.


Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 14:06:11 -0800, John Diacono
wrote:

I am in sales and see many different clients everyday. I use excel to colate
data about clients for among other things to keep track of who has paid and
who hasn't.
I need to collect this information and make a master report that I can
quickly view as needed.
Any suggestions as to a script to be able to do this would be most
appreciated.
Thanking you in advance
John D