Come to think of it, also what will work is to have a command button on sheet oethat when selected will get the current active cell on that sheet and then perform a search for it on sheet2. eg the contents in the active cell or selected cell in sheet one is "test" so then i would click the command button and it would look for test in sheet two.
|