| 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 |
| 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 | |||
Threaded Mode
