Hi, I have a list of data which is in a excel sheet. I would like to write a code which will loop through this list and search it in another sheet in the same workbook. Once it is found, it will then extract a particular data corresponding to that cell and put it in the first worksheet as a column entry. Can it be done by using macro? For eg, I want to find the list in column G in sheet 1 and then find it in sheet 2, if found - I want to find the data corresponding to abcd (if any). It is not fixed and can be in any column.
Last edited by a moderator: