| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically changing range of functions for monthly columns
My problem is:
I have one spreadsheet with a master list of data, and on another spreadsheet I have monthly columns of calculations based on this data. The range used in the formulas for these calculations varies from month to month. I need a way to create a new column for each month (keeping the same formulas) without manually changing the range every time. Any help would be appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have a chart automatically adjust range as I add data entri | Excel Discussion (Misc queries) | |||
| How to have a chart automatically adjust range as I add data entr. | Charts and Charting in Excel | |||
| Automatically insert time without changing. | Excel Discussion (Misc queries) | |||
| How to see columns from which values were not returned by HLOOKUP functions? | Excel Worksheet Functions | |||
| hiding columns automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
