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.