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) |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com