Hi Nigel

still can't see why a pivot table won't work ... you can refresh the pivot
table via code to show the lastest information .... and depending on how
much coding you want to do, i think you could automate the generation of the
individual lists (not that i've tried but can't see why not).

if this isn't the type of solution you're looking for, maybe you could
elaborate a bit more on what it is that you want.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Nigel" wrote in message
...
Hi,

I cannot use advanced fileter as the sheet where the information is kept
needs to be kept in the same view and cannot be changed. i need to create
my
list on a different sheet with the total amount of costs per client. pivot
table is not what i am lookinf for as this needs to adapted to run with
some
programming.
summary,
get information from client list on sheet A,
create client list ( with no doubled up client names )
create amount of enquiries per clients in list
create cost per client in list


Regards,

Nigel

"Nigel" wrote:

Hi,
I need to count and separate the number of specific clients into lists
with
their relative costs only. how can i acheive this? Example:
( say client list is B4:B1000. Project details C4:C1000 & Cost is
D4:D1000)
Client1 project details £1000
client2 project details £3500
client1 project details £ 500
client1 project details £2000
client2 project details £1500
client3 project details £4000

my list would be:
3 Client1 £3500
2 Client2 £5000
1 Client3 £4000

any help greatly appreciated.
thanks, Nigel