Drop down lists and transferring data

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!
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top