| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically linking subserviant worksheets to a master worksheet
I made a workbook detailing three different hospitals that i coordinate for.
i have one sheet for all the hospitals, and one sheet for each individual hospital with just that hospitals info in it, this totals four sheets. My goal is to put info into only the all inclusive worksheet and have it reflected in the corresponding hospital's list. I also want to be able to make updates to things already in the sheet and have it reflected in the corresponding hospitals sheet because there is a lot of info already entered that will be updated from time to time. Can that be Done and if so, How do i do it... -- thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamically linking subserviant worksheets to a master worksheet
Can be done with VBA or with formulas. I would just suggest using
some standard =reference formulas in combination with VLOOKUPs, SUMIFs, COUNTIFs, etc. Hard to give much more info without seeing the data itself. jcontrer wrote: I made a workbook detailing three different hospitals that i coordinate for. i have one sheet for all the hospitals, and one sheet for each individual hospital with just that hospitals info in it, this totals four sheets. My goal is to put info into only the all inclusive worksheet and have it reflected in the corresponding hospital's list. I also want to be able to make updates to things already in the sheet and have it reflected in the corresponding hospitals sheet because there is a lot of info already entered that will be updated from time to time. Can that be Done and if so, How do i do it... -- thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamically linking subserviant worksheets to a master workshe
what is the simplest form. I could show you a sample if you think it would be
of help for you to explain. please let me know. -- thanks in advance "JW" wrote: Can be done with VBA or with formulas. I would just suggest using some standard =reference formulas in combination with VLOOKUPs, SUMIFs, COUNTIFs, etc. Hard to give much more info without seeing the data itself. jcontrer wrote: I made a workbook detailing three different hospitals that i coordinate for. i have one sheet for all the hospitals, and one sheet for each individual hospital with just that hospitals info in it, this totals four sheets. My goal is to put info into only the all inclusive worksheet and have it reflected in the corresponding hospital's list. I also want to be able to make updates to things already in the sheet and have it reflected in the corresponding hospitals sheet because there is a lot of info already entered that will be updated from time to time. Can that be Done and if so, How do i do it... -- thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| synchronize worksheets with master worksheet | Excel Worksheet Functions | |||
| Master worksheet linking to multiple worksheets and using filter | Excel Discussion (Misc queries) | |||
| Linking 3 closed worksheets to master workbook template | Excel Worksheet Functions | |||
| Master Worksheet populated by other Worksheets? | Excel Worksheet Functions | |||
| Linking worksheets using a master document | Excel Discussion (Misc queries) | |||
Linear Mode
