| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying relative reference across worksheets
I want to set up a financial report with a separate worksheet for each month.
I will have column of receipts & expenses for the month and columns of receipts & expenses for YTD. The YTD will be computed by adding this months entry to the total from the previous month. When I copy the formulas they copy as an absolute reference so always refer to January. I could do this with Quattro but haven't found how to do it with Excel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas with relative references | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| How to use address from relative reference across worksheets? | Excel Worksheet Functions | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| Copying a Formula To Reference Multiple Worksheets | Excel Worksheet Functions | |||
Threaded Mode
