Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have input data in columns A through D and then formulas in columns E
through H that calculate off the data in columns A to D. For the formulas, I just double click the bottom right hand corner of the cell box and it autofills down. The next time I enter data in columns A through D, the formulas in columns E through H automatically calculate for me. EXCEPT one formula, it will not autofill, I have to double click the bottom right corner of the cell above for this formula to calculate in the present row. The formula is very simple too, it is just a cumulative profit. So if profits are in column G, and column H is cumulative, and the formula to be filled is in cell H33, it would just be H32+G33. Why is this one formula not autofilling???? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
Autofill does not seem to work when dragging right | Excel Discussion (Misc queries) | |||
Why doesn't autofill work in Excel? | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |