G
greg
Hi all, I posted this problem yesterday and was very grateful for the reply
below however I have carried out the instructions but it does not seem to
work or I do not understand it correctly, any other help would be great. p.s
I am inexperienced at macros so please explain in simple terms.Thank you
again in advance your help on this site is much appreciated.
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 (say 450) I wish to view into a cell
(say B1) 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.
the reply I recived was:
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
below however I have carried out the instructions but it does not seem to
work or I do not understand it correctly, any other help would be great. p.s
I am inexperienced at macros so please explain in simple terms.Thank you
again in advance your help on this site is much appreciated.
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 (say 450) I wish to view into a cell
(say B1) 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.
the reply I recived was:
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