|
Linking spreadsheets
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. -- dgg9879 ------------------------------------------------------------------------ dgg9879's Profile: http://www.excelforum.com/member.php...o&userid=33489 View this thread: http://www.excelforum.com/showthread...hreadid=532895 |
Linking spreadsheets
If you modify your approach and enter all the cheques on a single tab,
structured along these lines Col A - Date Col B - Cheque amount Col C - department You can then generate Pivot tables off that data to summarize the data any number of ways - by # of checks & totals department by date, by # of checks & totals for a range of dates (i.e., weekly, monthly, etc) Entering them all in a single place simplifies things and makes generating a variety of reports SO MUCH easier "dgg9879" wrote: 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. -- dgg9879 ------------------------------------------------------------------------ dgg9879's Profile: http://www.excelforum.com/member.php...o&userid=33489 View this thread: http://www.excelforum.com/showthread...hreadid=532895 |
Linking spreadsheets
You can also select the cell that you have your formula in and do a copy then
go to the sheet you want to put the answer in and do a "special paste". this will constantly update as you work on the original sheet. "dgg9879" wrote: 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. -- dgg9879 ------------------------------------------------------------------------ dgg9879's Profile: http://www.excelforum.com/member.php...o&userid=33489 View this thread: http://www.excelforum.com/showthread...hreadid=532895 |
| All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com