So, not sure if I titled my question correctly but here is what I am trying to do.
I want cell D3 from sheet 1 to look for cell E3 from another sheet. However, I want it to look for what is in E3 on the sheet that I create a hyperlink to in cell A3 of sheet 1.
So basically, cell D3 in sheet 1 knows it wants to look at cell E3 but does not know which sheet to look at until I enter the hyperlink.
Hopefully I have explained it well enough for someone much smarter than me to figure it out.
Thanks!!
I want cell D3 from sheet 1 to look for cell E3 from another sheet. However, I want it to look for what is in E3 on the sheet that I create a hyperlink to in cell A3 of sheet 1.
So basically, cell D3 in sheet 1 knows it wants to look at cell E3 but does not know which sheet to look at until I enter the hyperlink.
Hopefully I have explained it well enough for someone much smarter than me to figure it out.
Thanks!!