Dear All,
I have file of two sheets, in sheet1 is the original data. I need to have automatic data in sheet2 so that whenever i enter "Name" in sheet2 , the automatic correspondent value will be copied under "Location" from sheet1
thanks for any help
(please see sample file attached)
Bookmarks