benong
04-29-2011, 01:03 AM
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
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