Have searched through the forum but cannot find an answer to my problem. I have a range of cells in sheet1, lets say Range("A5:A15"). I want to replace the values with the results from a lookup.
I want to match the values from sheets("Sheet1").range("A5:A15") to sheets("Sheet2").range("E33:E47") and replace the values from sheets("Sheet1").range("A5:A15") with sheets("Sheet2").range("H33:H47").
Is this possible and if so, please can you offer some guidance on how to achieve.
Many Thanks
Matt
I want to match the values from sheets("Sheet1").range("A5:A15") to sheets("Sheet2").range("E33:E47") and replace the values from sheets("Sheet1").range("A5:A15") with sheets("Sheet2").range("H33:H47").
Is this possible and if so, please can you offer some guidance on how to achieve.
Many Thanks
Matt