Link to a number entered in a cell!

[owendodd]

Hi

What i am trying to do is i have a cell C4. This is where i am going to input a number. These numbers reside on a column B. They also reside on another sheet in the workbookWhat i want to do is when i enter a number into C4 it will automatically go find the row this number is on, on another. Any ideas?

I want to find a value on the current sheet and once entered in it links you to it on another sheet! A macro!

Cheers thanks!

 

[fairwinds]

Hi,

Try something like:

=HYPERLINK(CELL("address",INDEX(Sheet2!A:A,MATCH(C4,Sheet2!A:A,0))))

in an adjascent cell.

 

[owendodd]

Cheers!I have tried with a find Macro - Variable!

ActiveCell.FormulaR1C1 = "939712"
Sheets("Sep").Select
Range("H3").Select
Selection.Copy
Sheets("SCHEDULE2").Select
Columns("A:A").Select
Selection.Find(What:="939712", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Rows("344:344").Select
----------------------------------------------------------
I tried Recording a find Macro with a cell value being entered but i want to keep the cell value of H3 as a variable rather than a constant!

I recorded a Macro but for the number 939712 i want to set this as a variable value. When i run the macro the number i enter in H3 will be found on the SCHEDULE2 sheet!

 

[fairwinds]

Did you try the formula I posted? Adapted for your sheet it should read:

=HYPERLINK(CELL("address",INDEX(SCHEDULE2!A:A,MATCH(C4,SCHEDULE2!A:A,0))))

If this should work for you , I would prefere it rather than a macro.

 

[owendodd]

I did but i had no look with it. You understand what i am trying to do with the code. It is rather than have the value as a constant to adjust this as variable. I am not a VB programmer so i am having issue with this.

 

[owendodd]

I did but i had no look with it. You understand what i am trying to do with the code. It is rather than have the value as a constant to adjust this as variable. I am not a VB programmer so i am having issue with this.

 

[owendodd]

I did but i had no look with it. You understand what i am trying to do with the code. It is rather than have the value as a constant to adjust this as variable. I am not a VB programmer so i am having issue with this.

 

[owendodd]

I did but i had no look with it. You understand what i am trying to do with the code. It is rather than have the value as a constant to adjust this as variable. I am not a VB programmer so i am having issue with this.

 

[owendodd]

Cheers!But still no luck

I did but i had no look with it. You understand what i am trying to do with the code. It is rather than have the value as a constant to adjust this as variable. I am not a VB programmer so i am having issue with this.

 

[owendodd]

Cheers!But still no luck

I did but i had no look with it. You understand what i am trying to do with the code. It is rather than have the value as a constant to adjust this as variable. I am not a VB programmer so i am having issue with this.