I am setting up several spread sheets. One is to Transport Costs, one is for
Food Costs, etc. One of the spread sheets will be a budget spread sheet for
the whole month. What I need to do, is have a way of drawing the totals of
the formulae used in the individual spreadsheets into the Budget spread sheet.

Eg.

Spread sheet 1 Spread sheet 2

A B A
B

Transport Food

1 Road Tax £180 1 Bread
£0.75
2 Insurance £800 2 Eggs
£1.20
3 Fuel £300 3 Orange Juice
£1.40
4 4 Butter
£0.87
5 Total =sum(b1:b3) 5 Milk
£0.80
6
7 Total
=sum(b1:b5)


Spread sheet 3

Budget Spread sheet

A B

1 Transport Costs Drawn from spread sheet 1, cell b5
2 Food Costs Drawn from spread sheet 2,
cell b7
3
4 Total Costs =sum(b1:b2)

My efforts up to now, have only managed to copy the actual formulae between
spread sheets, not the results of the formulae. I had no problems achieving
the results in Supercalc 5, but can't seem to do it in Excel 2003.

Help.