software

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.

lt;1 Transport Costs Drawn from spread sheet 1, cell
b5gt;
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

quot;PeterNoconquot; gt; wrote in message
...
gt;I am setting up several spread sheets. One is to Transport Costs, one is
gt;for
gt; Food Costs, etc. One of the spread sheets will be a budget spread sheet
gt; for
gt; the whole month. What I need to do, is have a way of drawing the totals of
gt; the formulae used in the individual spreadsheets into the Budget spread
gt; sheet.
gt;
gt; Eg.
gt;
gt; Spread sheet 1 Spread sheet 2
gt;
gt; A B A
gt; B
gt;
gt; Transport Food
gt;
gt; 1 Road Tax �180 1 Bread
gt; �0.75
gt; 2 Insurance �800 2 Eggs
gt; �1.20
gt; 3 Fuel �300 3 Orange Juice
gt; �1.40
gt; 4 4 Butter
gt; �0.87
gt; 5 Total =sum(b1:b3) 5 Milk
gt; �0.80
gt; 6
gt; 7 Total
gt; =sum(b1:b5)
gt;
gt;
gt; Spread sheet 3
gt;
gt; Budget Spread sheet
gt;
gt; A B
gt;
gt; 1 Transport Costs Drawn from spread sheet 1,
gt; cell b5
gt; 2 Food Costs Drawn from spread sheet 2,
gt; cell b7
gt; 3
gt; 4 Total Costs =sum(b1:b2)
gt;
gt; My efforts up to now, have only managed to copy the actual formulae
gt; between
gt; spread sheets, not the results of the formulae. I had no problems
gt; achieving
gt; the results in Supercalc 5, but can't seem to do it in Excel 2003.
gt;
gt; Help.