Do the following:

1. Select any cell
2. Click Insert-Name-Define
3. Define a name
4. Click Edit Ctrl+G, Jump to the location

You can jump to any location from any worksheet from within the Workbook.

Challa Prabhu

"Pete T" wrote:

I need to set up a file where I can enter a plot number in cell a1 (fixed
with freeze panes), have a range of plot numbers in column a and then
goto/jump to the relevant row for that plot in column b.

Suggestions appreciated..