Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill down not progressing
I have set up a workbook where I have different number on 1 page, and another
pages has their totals per row based on what my clients have ordered. Anyways, on my second pages I have many columns, with formals refering back to page 1 (ie: =Calculation!AO102+Calculation!AZ102). When I fill down on about 75% of my columns, the formals progress down ...from AO102 to AO103, etc. However on the remaining columns, when it fills down all the cells have the exact same formula, and do not progress. The formula that is copied to each cell is =Calculation!B109+Calculation!Q109+Calculation!X10 9+Calculation!AE109+Calculation!AK109+Calculation! BF109. I have tried to copy and paste the formulas and everything else I can think of to make it progress down to the next row without having to recreated it each time with new cell reference. Any ideas as to why most of the cells will work and the rest don't? (Working on B2TR Excel, by the way) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
basics? | New Users to Excel | |||
Auto fill option | New Users to Excel | |||
Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) |