Hi,

I have query in excel, where in, if I enter a value in sheet1 in any cell, it should automatically open sheet2 and point to the corresponding cell in sheet2.
How do i get excel to make a loop through the entire cell value in sheet2 and then match the value in sheet1 and correspond it to the value in sheet2?

Can anyone help on this?

Thanks