hi guys !! plz help me on this. how do i create a code to find a particular cell in ms excel.
i need to look for a keyword in one sheet, take the value which is 2 col to the right and 2 rows below, and then paste that value in another sheet.
e.g if the keyword is in the cell F1, i need to take the value H3 and so on..