Move cursor in cell on the basis of cell value with excelvba

Hi all,

Pls find attachment of file which contains 2 sheets having name as Test & DataTest

in Test sheet I have knew the address of the column value which is in the DataTest sheet

Now due to heavy list, navigation in DataTest sheet is very tiresome job.

Is there any solution that if I click on any cell of column B & C of Test sheet, the cursor automatically move on to the DataTest sheet (prescribe cell.

thanks in advance...

Originally Posted by Eastw00d

Hi, maybe you can use this:

Please Login or Register  to view this content.

Cheers Erwin

thank you so much