Read out this post http://www.ozgrid.com/VBA/find-method.htm

To create a Visual Basic Sub procedure, follow these steps:
Start Excel.
Press ALT+F11 to start the Visual Basic editor.
On the Insert menu, click Module.
Enter the Sub procedure code in the module sheet.
Press ALT+F11 to return to Excel.
To run a Visual Basic Sub procedure, follow these steps:
On the Tools menu, point to Macro and then click Macros.
Select the macro (Sub procedure) that you want and then click Run.

If this post helps click Yes
-------------
Jacob Skaria


"garyh" wrote:

Is there a way to go to a cell in another worksheet that has an identical
value of a cell in another worksheet? Example:

Current cell location: worksheet1.A1

Reference cell location: worksheet1.A2

Cell to go to: worksheet2.[same data that is located in worksheet1.A1]

Any help with this is greatly appreciated. Thanks.

G