K konijay New Member Oct 31, 2012 #1 hello all, column A contains employee numbers column X contains employee's salary amount I need hyperlink to employee's salary when employee number is clicked(same row) I am getting circular reference error when I do this... =hyperlink(X1,A1) thanks
hello all, column A contains employee numbers column X contains employee's salary amount I need hyperlink to employee's salary when employee number is clicked(same row) I am getting circular reference error when I do this... =hyperlink(X1,A1) thanks
Luke M Excel Ninja Staff member Oct 31, 2012 #2 You'll need to include both the workbook and sheet name, and it needs to be in quotes (as you want the text string, not the contents of the cell X1). =HYPERLINK("[Your book.xls]'My Sheet'!X1",A1)
You'll need to include both the workbook and sheet name, and it needs to be in quotes (as you want the text string, not the contents of the cell X1). =HYPERLINK("[Your book.xls]'My Sheet'!X1",A1)
K konijay New Member Nov 1, 2012 #3 My issue is the A1 part, not "[Your book.xls]'My Sheet'!X1"... Isn't circular reference error coming from A1 since it cannot look at itself? I want to be able to click the employee number(whatever the number that's already in A1) and it jumps to salary(X1).
My issue is the A1 part, not "[Your book.xls]'My Sheet'!X1"... Isn't circular reference error coming from A1 since it cannot look at itself? I want to be able to click the employee number(whatever the number that's already in A1) and it jumps to salary(X1).
Luke M Excel Ninja Staff member Nov 1, 2012 #4 Yes, as you found out, you can't do that. =) Assuming employee numbers are in col A, you would put the formula in another column (maybe insert a new col B?) and then hide col A.
Yes, as you found out, you can't do that. =) Assuming employee numbers are in col A, you would put the formula in another column (maybe insert a new col B?) and then hide col A.
