| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying a formula with different sheet refs
I need to fill in the formula, "=IF(MAX(Sheet2!B5:B200)(TODAY()-21),"not
due","due")" in sheet1 from cell b2 to B200 but to change only the Sheet ref so that b3 refers to sheet3, and b4 refers to sheet4 and so on. When I try to fill down, Excel changes the range of cells, not the sheet nos and if I try to copy and paste, the same thing happens. Would be grateful of any help please. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble copying and pasting a formula | Excel Worksheet Functions | |||
| Balance sheet Formula | Excel Discussion (Misc queries) | |||
| Copying linked cell references. | Excel Worksheet Functions | |||
| How do I copy a result without copying the formula? | Excel Discussion (Misc queries) | |||
| Formula for copying a sequence for every 8th cell | Excel Worksheet Functions | |||
Linear Mode
