PDA

View Full Version : multiply names in variable (userform)



danovkos
08-18-2010, 11:57 PM
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.


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