Hello Group,

I've in me Sheet table with: Product, Manager, etc
When Manager get new Product in excel is new row for ex:

Product Manager Value
prodA Ann 10
prodB Ann 2
ProdC Tom 15
prodD Tom 8
prodE Eva 20
prodF Ann 4
prodG Eva 10
prodH Tom 11

This table is upgrade every month (new products and new managers).
Value in collumn Product is unique.

I've in my sheet ListBox. My questions?
1. How add to ListBox all Managers without duplicates?
ListBox for ex:

Manager
-------
Ann
Eva
Tom

2. How add in this ListBox collumn Bonus with percent value?

Manager Bonus%
-------- --------
Ann 10
Eva 8
Tom 5

3.How add new sheet with:
Manager Value Bonus%
Bounus$
Ann =(10+2+4) from first table 10 (from ListBox)
=Value*Bonus%
Eva =(20+10) 8
=Value*Bonus%
Tom =(15+8+11) 5
=Value*Bonus%


More thx

Pawel R