Link same dates

[kiki1989sb]

Hi everyone!

In collumn A i have dates, in row 1 are the same dates...
What i want to click on certain date in collumn A and thenautomatically link to the same cell in row 1... Attached picture...
Ashampoo_Snap_2014.12.18_10h56m36s_001_.png

[samba_ravi]

C1=index($a:$a,column())
c2=index($b:$b,column())

[kiki1989sb]

Thank you for your answer, but i don't get it....

In collumn A and row 1 are static dates, so when i click on any date in collumn A i want it to automatically mark the same that date in row 1....

Is that possible?

[samba_ravi]

Pls attach sample workbook with some examples

[kiki1989sb]

OK, thank you...

When i click on 25.12.2014 in Collumn A, I want it to automatically refers (something like a hyperlink) to the same match in row 1 (for an examople to mark that whole collumn or just the cell), dates are not necessarily in the exact order like in example...

ATTACH]365620[/ATTACH]

[samba_ravi]

see the attached file
it is a macro unable workbook

[kiki1989sb]

Thank you so much, I thought that cant be solved by formula/data validation for an example...