B
Ben
I need to be able to count how many clients are repeated in a record of
attendance sheet. Clients are identified with a unique client number.
I would like to run a macro that searched the record sheet for clients with
multiple entries and copies their details (which are organised across a row)
onto another sheet within the work book. Would also like to total the amount
of money they received.
Date Client Number Voucher# Amount Provided
30/03/2009 66 O0685 $ 65.00
12/12/2008 67 O0392 $ 75.00
9/06/2009 67 P 0021 $ 150.00
22/06/2009 68 P 0686 $ 100.00
In the above example client # 67 is entered twice so I need the macro to
copy that into another worksheet so it looks like this
Client# Number Total
of visits Received
67 2 $225.00
Is this possible?
No Pivot Tables Please
attendance sheet. Clients are identified with a unique client number.
I would like to run a macro that searched the record sheet for clients with
multiple entries and copies their details (which are organised across a row)
onto another sheet within the work book. Would also like to total the amount
of money they received.
Date Client Number Voucher# Amount Provided
30/03/2009 66 O0685 $ 65.00
12/12/2008 67 O0392 $ 75.00
9/06/2009 67 P 0021 $ 150.00
22/06/2009 68 P 0686 $ 100.00
In the above example client # 67 is entered twice so I need the macro to
copy that into another worksheet so it looks like this
Client# Number Total
of visits Received
67 2 $225.00
Is this possible?
No Pivot Tables Please