Hi ,

Can any one help /suggest any reference for my below need.

I have to bind a drop down with values like (ParentFile1_Account, ParentFile2_Location,....) in source excel workbook. (say sheet1)
On selecting ParentFile1_Account , it has to ask for column Name / Column Header Alphabet.

On giving the column details, it has to take unique values from that column and bind it to source excel. (say sheet2)
Two buttons - Validate and Reset.
on clicking validate, it has to compare 2 sheets (sheet2 column cell value is present in another sheet or not.)
kindly guide.