Using a drop down to transfer to correct worksheet

[Dreamwine59]

Hi,
I would like to take data from a work sheet in work book A, and using a drop down list or radio button selections transfer the data to workbook B. The worksheets in B would be named from the drop downs or radio selections in A. The cells will all be a direct transfer to same cells in different worksheets in B. The worksheets will be different weeks of the month ex. Week1, week 2 ect.
The data will come from refreshing a pivot table in Work book A every week.
So the process would go;
1.EE opens workbooks A and B.
2.EE updates pivot table,then picks from the drop down what sheet the data will transfer too, then hits transfer button to move data to overwrite data in a scorecard
3.EE closes/saves both work books.

I have been able to record the transfer to the direct cells on the scorecard, but can't figure out how to make the dropdown work.
Thanks
Deb

[mikeTRON]

What about the dropdown can you not do? Are you trying to make an If statement off the dropdown?

Without seeing what you are actually using I would do something like this
(Add a named range to the drop down cell so it can be easily/dynamically grabbed with the vba)

Please Login or Register  to view this content.

[Dreamwine59]

Sorry, I was trying to attache the 2 spreadsheets and they are erroring out. I don't know if I am being blocked by your site or my company.

I have modified the 2 spreadsheets so the week no longer matters.

My VBA is rusty to say the least, but I am able to get the scorecard to update.

Thanks