Q : How can i hyperlink data from sheet2 to sheet1??What is the formula?
I want my data in sheet2 automatically hyperlink in specific cell in sheet1
for example:[/COLOR] when i type 2009 in C3 of sheet2, it automatically hyperlinked to cell C3 in sheet1..
how can i do that?
Bookmarks