Formula that mimics Ctrl+F

[ARVALLEN]

I am looking for a way to find data in a spreadsheet the way Control F does.

Would like to be able to have a cell where users will type the 6 digit schedule # and have the spreadsheet go right to the first occorance of this Number.

Any help?

[VBA Noob]

Maybe this link about a event macro would help you

http://www.excelforum.com/showthread.php?t=594168

VBA Noob

[Ron Coderre]

This is a bit messy, but it works without macros:

With your list of Sched_Nums is in A1:A20

And....
D1: (a Sched_Num input by a user)

Then....try this:
E1: =HYPERLINK("file://"&SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),"[","")&"#"&CELL("address",INDEX(A1:A20,MATCH(D1,A1:A20,0))),"Enter Sched_Num__then click here")

That cell will display: "Enter Sched_Num__then click here"
and it will also be a dynamic hyperlink to the referenced Sched_Num.

The user enters a Sched_Num in cell D1 then clicks on E1.

Note: if the list is on another sheet...
The INDEX function must refer to that list
AND...
The sheet name must be entered after the # in the formula, followed by an exclamation mark, then the cell address:

Example:
If the list is in a sheet named: SchedSheet
then:
"#SchedSheet!"&CELL...etc

Is that something you can work with?