| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
update formula in column when another cell formula is changed
Hi !
How can I change cell formulas automatically when I change another cell. For example say: For June: A1 through A250 cell formula is =+B7+AJ7+AR7+BA7+BI7+BQ7 every month it will have a new cell added to the formula For July, these cell formulas will be =+B7+AJ7+AR7+BA7+BI7+BQ7+BY7 I want to automatically update A2 through A250 formulas by only changing the A1 formula. I know that I could drag the new formula down from A1 but I have 10 sheets that need to be changed and I would like to find a way to automate this to prevent human error...(mine!). Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel cell in formula not refreshing answer cell | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| What formula will get a cell to update when the month changes | Excel Worksheet Functions | |||
| Update cell reference within a formula | Excel Discussion (Misc queries) | |||
| How do I set a formula that indicates a if a cell value changed? | Excel Worksheet Functions | |||
Threaded Mode
