| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Absolute Cell refernce Not working
I'm trying to do an absolute cell reference but the reference is on another
"tab" or sheet. Same file just different file. I only want the column to change but to fill the row down. Formula using: =Period1!E$5/Period1!E$4 Period1 is the sheet on the same file and I want to fill down...not over so switch columns not row...and fill down! Thanks All. Its for a grade sheet for my teaching. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute reference (F4 Key) not working | Excel Discussion (Misc queries) | |||
| Using a single cell refernce to change multiple formulas | Excel Worksheet Functions | |||
| need 2 create refernce in formula thatpoints to cell in other tab | Excel Discussion (Misc queries) | |||
| Using absolute cell refernce and inserting rows | Excel Worksheet Functions | |||
| Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
Threaded Mode
