Solved: dynamic list

[benong]

hi,
i've a list of data on sheet 1, column a to column e.


Sheet 1 Sheet 2
col A - data unique list of sheet 1 col B data
col B - first name data from sheet 1 col C (relative to sheet 2 col B data)
col C - last name
col D - data
col E - data
i want to have a unique list of data base on of sheet 1 column A data to be copy to sheet 2 column A sorted in ascending order. The sheet 2 column B data is relative to the unique list from Sheet 2 column A.
Any changes(add/delete/modify) in sheet 1 data will reflect to sheet 2 immediately.
Currently i'm doing it manually. I want to automate it via vba.
Your guidance is greatly appreciated, thanks.
regards

[BrianMH]

Can you upload an example file please?

[shrivallabha]

Have you tried Pivot Table? Maybe before proceeding to VBA, have a look at it if you haven't.

[benong]

dear BrianMH,
attached is an example. the name bill was duplicate in column A.
regards

[BrianMH]

so you don't want entries 4 AND 10?

[benong]

i need all the unique values from column B.
This means i need the first value(4) it find.

[Bob Phillips]

Try this

[benong]

Dear xld,
many thanks for your guidance :)