D
dgg9879
I previously asked for help on linking spreadsheets. Here is my origina
post and the reply I received:
At work I have several spreadsheets for adding cheques eg 5 cheques fo
the Aquatic centre adds up to $100, 7 cheques for animal registratio
adds to $200 etc. The spreadsheet adds the number of cheques and total
automatically.
There is also a master spreadsheet to summarise all the totals. Instea
of showing the value of every cheque for the Aquatic Centre, it jus
shows the number of cheques and the total, and so on,for all th
cheque categories and a master total for all cheques.
After I finish entering all the categories of cheques in individua
spreadsheets I enter them in for the master spreadsheet.
Please someone tell me if it is possible to link the individua
spreadsheets in with the master spreadsheet so that the maste
spreadsheet is updated automatically as the individual spreadsheets ar
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 th
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 b
creating lots of worksheets within the one worksheet. I did this b
copying and pasting from the original spreadsheets because they ar
formatted with company logo etc and it would take quite a while to d
them myself from scratch. I found that I was able to get the tota
number of cheques to be automatically updated in the master spreadshee
for each cheque category but not the dollar values. This seems strange
Whenever I tried a horozontal line appeared on the master spreadshee
where the dollar total should appear. I was not able to play aroun
with the spreadsheets much because they are password protected. But fo
the dollar values the column that adds them has been merged so that th
formula to sum is something like =SUM(A3:b7) while the column fo
adding the no. of cheques is a single column.
What are the possible reasons for the dollar values not automaticall
updating?
Is it becase the column is 2 cells wide? Or could it be to do with th
password protection?
I will find out tomorrow if anyone know the password to unprotect th
spreadsheet. Another option would be to just copy the cells that I nee
for formatting such as the company logo and start from scratch to get i
working that way
post and the reply I received:
At work I have several spreadsheets for adding cheques eg 5 cheques fo
the Aquatic centre adds up to $100, 7 cheques for animal registratio
adds to $200 etc. The spreadsheet adds the number of cheques and total
automatically.
There is also a master spreadsheet to summarise all the totals. Instea
of showing the value of every cheque for the Aquatic Centre, it jus
shows the number of cheques and the total, and so on,for all th
cheque categories and a master total for all cheques.
After I finish entering all the categories of cheques in individua
spreadsheets I enter them in for the master spreadsheet.
Please someone tell me if it is possible to link the individua
spreadsheets in with the master spreadsheet so that the maste
spreadsheet is updated automatically as the individual spreadsheets ar
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 th
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 b
creating lots of worksheets within the one worksheet. I did this b
copying and pasting from the original spreadsheets because they ar
formatted with company logo etc and it would take quite a while to d
them myself from scratch. I found that I was able to get the tota
number of cheques to be automatically updated in the master spreadshee
for each cheque category but not the dollar values. This seems strange
Whenever I tried a horozontal line appeared on the master spreadshee
where the dollar total should appear. I was not able to play aroun
with the spreadsheets much because they are password protected. But fo
the dollar values the column that adds them has been merged so that th
formula to sum is something like =SUM(A3:b7) while the column fo
adding the no. of cheques is a single column.
What are the possible reasons for the dollar values not automaticall
updating?
Is it becase the column is 2 cells wide? Or could it be to do with th
password protection?
I will find out tomorrow if anyone know the password to unprotect th
spreadsheet. Another option would be to just copy the cells that I nee
for formatting such as the company logo and start from scratch to get i
working that way