I need help trying to create a formula to pull through figures for a range of cells.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o></o>
I have 2 tabs – Result & Calculation. <o></o>
<o></o>
On the result worksheet I have 8 months all with a price and pages totals. These numbers are then used by the calculation worksheet to produce the grand total.<o></o>
<o></o>
On the calculation worksheet I have the Price & Pages totals from the result sheet and then some costs calculations based on the Price & Pages numbers. This then gives me the Grand Total which I then show back on the Results worksheet.
<o></o>
<o></o>
What I want to do is find a way of automatically changing the Price & Pages totals on the calculation sheet for each month as per the results page figures so I can then return the Grand Total figure for each month to the results worksheet in as smooth and quick as way as possible.
<o></o>
<o></o>
<o></o>
All help would be much appreciated
fficeffice" /><o></o><o
></o>I have 2 tabs – Result & Calculation. <o
></o><o
></o>On the result worksheet I have 8 months all with a price and pages totals. These numbers are then used by the calculation worksheet to produce the grand total.<o
></o><o
></o>On the calculation worksheet I have the Price & Pages totals from the result sheet and then some costs calculations based on the Price & Pages numbers. This then gives me the Grand Total which I then show back on the Results worksheet.
<o
></o> <o
></o>What I want to do is find a way of automatically changing the Price & Pages totals on the calculation sheet for each month as per the results page figures so I can then return the Grand Total figure for each month to the results worksheet in as smooth and quick as way as possible.
<o
></o> <o
></o><o
></o>All help would be much appreciated
