hi
pls. can you help me with this code?
I try to do following.
My table is e.g. 1000 rows and in 3 columns.
Col A – ID
Col B – name
col C – amount

IDs can be in table more then once.

I want to set in variables (MENA, SUMAR) data in this way. This variable i will use in userform.

If is in table ID more then once, it set to variable MENA all names with the same ID (something like VLOOKUP, but not only the first value will be return but all will be set in variable. In variable SUMAR will sum all amount from column C (amount) for all IDs.

e.g.
HTML Code:
A        B         C
10      dan      100
12      john      200 
500     sue       300 
12       pat       400 
30      lock       500 
10      car        600


After loading a user form for ID 10 will appear:

ID - 10
name – dan, car
sumar – 700

or for ID 12

ID - 12
name – john, pat
sumar – 600

Pls. how can i do that?
thx a lot