purrplegrrl77
New Member
- Joined
- Oct 21, 2009
- Messages
- 11
Hello,
I created a spreadsheet at work which calculates a dollar amount used by hospitals we service. This dollar amount changes each year. The spreadsheet contains the following items:
Input Data Tab – This is where the data used to calculate the dollar amount for each hospital is entered. This tab also has a drop down list of hospitals we service. Each hospital has a line on the spreadsheet and several columns of data needed to calculate the dollar amount. The columns of data are different for each hospital.
Output Tab – This is sent to our hospitals each year. It shows the dollar amount calculated. When I choose a hospital from the drop down list on the Input Data Tab, I click on the Output Tab to see the dollar amount calculated. (This tab pulls information from the Input Data Tab by using the VLookup function and another complex formula that will calculate the dollar amount for each hospital).
Here is my issue:
The 2010 dollar amount result calculated for each hospital on the Output Tab needs to be transferred to the 2011 spreadsheet’s Input Data tab to calculate the next year’s dollar amount. Is there a way that this can be done without choosing each hospital from the drop down list, then clicking the Output Tab, then copy/paste the result into each hospital's line on the 2011 Input Data Tab? We have hundreds of hospitals and this would be a very time consuming task.
Ultimately, I would like to add another tab to the 2010 spreadsheet which will house each hospital’s dollar amount without the need to choose each hospital from the drop down list. I would then copy/paste the information from this tab into the 2011 spreadsheet all at once. Is this possible?
Thank you very much for taking the time to read my long question!
I created a spreadsheet at work which calculates a dollar amount used by hospitals we service. This dollar amount changes each year. The spreadsheet contains the following items:
Input Data Tab – This is where the data used to calculate the dollar amount for each hospital is entered. This tab also has a drop down list of hospitals we service. Each hospital has a line on the spreadsheet and several columns of data needed to calculate the dollar amount. The columns of data are different for each hospital.
Output Tab – This is sent to our hospitals each year. It shows the dollar amount calculated. When I choose a hospital from the drop down list on the Input Data Tab, I click on the Output Tab to see the dollar amount calculated. (This tab pulls information from the Input Data Tab by using the VLookup function and another complex formula that will calculate the dollar amount for each hospital).
Here is my issue:
The 2010 dollar amount result calculated for each hospital on the Output Tab needs to be transferred to the 2011 spreadsheet’s Input Data tab to calculate the next year’s dollar amount. Is there a way that this can be done without choosing each hospital from the drop down list, then clicking the Output Tab, then copy/paste the result into each hospital's line on the 2011 Input Data Tab? We have hundreds of hospitals and this would be a very time consuming task.
Ultimately, I would like to add another tab to the 2010 spreadsheet which will house each hospital’s dollar amount without the need to choose each hospital from the drop down list. I would then copy/paste the information from this tab into the 2011 spreadsheet all at once. Is this possible?
Thank you very much for taking the time to read my long question!