Using the results of formulae between different spreadsheets.

[PeterNocon]

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.

[Bernard Liengme]

<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" <PeterNocon@discussions.microsoft.com> wrote in message
news:C7810B69-8214-404B-BF92-FC82DDDED36C@microsoft.com...
>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.