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.

<1 Transport Costs Drawn from spread sheet 1, cell
b5
Use =Sheet1!B5 to get this

You can type the entire formula OR
type = then open Sheet1 and click on B5

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PeterNocon" wrote in message
...
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.