jump to

G

greg

Hi all, I have an inventory with 500 rows all with a number i.d Is there a
command by where I can input the i.d I wish to view into a cell at the top
of the page and the row will be shown even if it is off the visible page. I
know I could filter the column but wondered if there was another way. Thank
you in advance.
 
D

Don Guillett

right click on the sheet tab>view code>copy paste this. Modify to suit.
As written, this finds the number in a9 in col A.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.address <> "$A$9" Then Exit Sub
x = Columns(1).Find(Target, after:=ActiveCell).address
Application.Goto Range(x), Scroll:=True
End Sub
 
G

Gilles Desjardins

You could use Data, Form, Criteria. That way you can see the whole record in
the same dialog box.

Gilles
 
Top