Reference cells in seperate worksheet
 

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

Reference cells in seperate worksheet
 

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

Reference cells in seperate worksheet
 

I understand what you said and know how to do that, however, that is not what
I am trying to do. Let me try to explain further:

Sheet 1 - cell J7 has 59-01 typed in it.

Sheet 2 - cell B14 lists the value of 59-01.

Sheet 1 - cell L7 should display the value of sheet 2, cell B14 and so on.

So, if cell J7 (on sheet 1) changes to 59-05, cell L7 on sheet 1 should
reflect the value from sheet 2, cell E14 which is the value of 59-05.

Does that make sense?
--
Chris


"Bernard Liengme" wrote:

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

Reference cells in seperate worksheet
 

Frankly, no. Want to try that again?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"HR Gal" wrote in message
...
I understand what you said and know how to do that, however, that is not
what
I am trying to do. Let me try to explain further:

Sheet 1 - cell J7 has 59-01 typed in it.

Sheet 2 - cell B14 lists the value of 59-01.

Sheet 1 - cell L7 should display the value of sheet 2, cell B14 and so on.

So, if cell J7 (on sheet 1) changes to 59-05, cell L7 on sheet 1 should
reflect the value from sheet 2, cell E14 which is the value of 59-05.

Does that make sense?
--
Chris


"Bernard Liengme" wrote:

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