ExcelBanter - More problems linking spreadsheets

I previously asked for help on linking spreadsheets. Here is my original
post and the reply I received:

At work I have several spreadsheets for adding cheques eg 5 cheques for
the Aquatic centre adds up to $100, 7 cheques for animal registration
adds to $200 etc. The spreadsheet adds the number of cheques and totals
automatically.

There is also a master spreadsheet to summarise all the totals. Instead
of showing the value of every cheque for the Aquatic Centre, it just
shows the number of cheques and the total, and so on,for all the
cheque categories and a master total for all cheques.

After I finish entering all the categories of cheques in individual
spreadsheets I enter them in for the master spreadsheet.

Please someone tell me if it is possible to link the individual
spreadsheets in with the master spreadsheet so that the master
spreadsheet is updated automatically as the individual spreadsheets are
updated. And most importantly, tell me how to do this!

I am Australian so you will have to excuse my spelling of cheque.

--------------------------------------------------------------------------------

easy
on your master sheet in the cell for the total you want to show type =
and
then click on the total cell from your other worksheet,and for the
number of
cheques type= and click on the cel that shows the number of cheques.

I tried this advice at home and it worked. I tried it at work by
creating lots of worksheets within the one worksheet. I did this by
copying and pasting from the original spreadsheets because they are
formatted with company logo etc and it would take quite a while to do
them myself from scratch. I found that I was able to get the total
number of cheques to be automatically updated in the master spreadsheet
for each cheque category but not the dollar values. This seems strange.
Whenever I tried a horozontal line appeared on the master spreadsheet
where the dollar total should appear. I was not able to play around
with the spreadsheets much because they are password protected. But for
the dollar values the column that adds them has been merged so that the
formula to sum is something like =SUM(A3:b7) while the column for
adding the no. of cheques is a single column.

What are the possible reasons for the dollar values not automatically
updating?

Is it becase the column is 2 cells wide? Or could it be to do with the
password protection?

I will find out tomorrow if anyone know the password to unprotect the
spreadsheet. Another option would be to just copy the cells that I need
for formatting such as the company logo and start from scratch to get it
working that way.

--
dgg9879
------------------------------------------------------------------------
dgg9879's Profile: http://www.excelforum.com/member.php...o&userid=33489
View this thread: http://www.excelforum.com/showthread...hreadid=534081