| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy drag formula down cells
I have a formula in column D. It references cells from another sheet (Sales)
in the same workbook that are in column C. I want to drag the formula down column D and have it reference cells moving across the columns, referencing the same rows from the other sheet. EG: SUM(Sales!C63:C64)/Sales!C60 becomes SUM(Sales!D63:D64)/Sales!D61. At the moment, when I drag this formula down the column the row data changes but the column data remains the same. The opposite to what I want to happen. -- Thank you, Colin. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can we drag-copy cells from evry five row to every row | Excel Discussion (Misc queries) | |||
| Can I fix a format so it doesn't change when I drag or copy/paste | Excel Worksheet Functions | |||
| Drag copy between worksheets | Excel Discussion (Misc queries) | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Cannot drag content or formula to another cells | Excel Discussion (Misc queries) | |||
Threaded Mode
