Hyperlink with values

**kroz** · 01-15-2009, 05:28 AM

Hi all,

I want two sheets in the same file and i want to link a cell from one to a cell from the other.
Here's what i need to do:

hyperlink on cell D2 of sheet1 so that when clicked it will take me to cell A2 of sheet2, BUT i need to transfer the info from cell D2 to cell A2.
I'm doing a query in every sheet based on cell A2 so if i input something in cell A2 of sheet1 i get the info i need for query 2 in cell D2 (by clicking on d2/sheet1 i automatically do query 2 based on it). This would be easy if i could link cell A2 in sheet2 with cell D2 in sheet1 BUT i can't have code in cell A2 since i sometimes only have query 2 active (they can be independent).

If i lost you in details let me know.

**Cheeky Charlie** · 01-15-2009, 08:37 AM

you lost me in details

I would like to help, please break the explanation down into smaller steps

CC

**kroz** · 01-15-2009, 08:53 AM

in sheet 1 i have this

A________________B ... D
query item________formula

In sheet 2 i have this
A________________B ... D
query item________formula
The two sheets are linked - if i launch a query in sheet1 i can use the value in cell D to launch the query in sheet2:
Sheet 1
A________________B ... D
query item________formula
Sheet2
A________________B ... D
D2________________formula

I could have done a A2=Sheet1!D2 in sheet2 but i can't have formulas in sheet2/A2 - i can launch independent queries in sheet2 which would require adding query item manually in A2/sheet2

I hope that clarifies things a bit