If the cell K5 on Sheet2 has the number 666, then on any other sheet, the
formula =Sheet1!K5 will display 666.
If the sheet name has spaces, you need to put the name within single-quotes
='Another Sheet'!K2
The easiest way to get it right is:
On the sheet where you want the result: type an equals sign in the cell (=)
Open the other sheet; click on the cell to be referenced
Either tap the ENTER key or click the green arrow on the Formula Bar
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"HR Gal" wrote in message
...
I have a worksheet that I need help with.
What I am trying to accomplish:
J7=range/step - this refers to salary (range/step table is on seperate
worksheet)
L7=annual salary (would like this to update based on the J7 cell when it
changes, ie; if range/step is 65-01 it displays the annual salary for
65-01.
if you change it to 65-05 it should display annual salary for 65-05
automatically)
Can anyone advise how to accomplish this? Thank you in advance.
--
Chris