S
Striske
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!X109+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)
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!X109+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)