Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference web query data in seperate worksheet | Excel Worksheet Functions | |||
Adding / deleting cells to worksheets from a seperate worksheet | Excel Discussion (Misc queries) | |||
How do I change the Row Reference from a seperate worksheet. | Excel Discussion (Misc queries) | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |