Can I Change Displayed Data Through Data Validation?
I have 2 workbooks which we'll call A & B. Workbook A contains a dropdown
box created through data validation which lists each month of the year. Workbook B contains 12 sheets, one for each month of the year with the data I need. What I'm looking to be able to do is select a month from the dropdown in workbook A and pull in the month's data from the appropriate sheet in workbook B. Can this be done automatically upon selection of the month, or does a procedure need to be written to handle the refresh? Any help would be much appreciated. |
Can I Change Displayed Data Through Data Validation?
This can be done through VBA. you can write a procedure that will react on
change cell value change. Once the change is made, copy the sheet from A to B. Regards Igor "TEK" wrote: I have 2 workbooks which we'll call A & B. Workbook A contains a dropdown box created through data validation which lists each month of the year. Workbook B contains 12 sheets, one for each month of the year with the data I need. What I'm looking to be able to do is select a month from the dropdown in workbook A and pull in the month's data from the appropriate sheet in workbook B. Can this be done automatically upon selection of the month, or does a procedure need to be written to handle the refresh? Any help would be much appreciated. |
Can I Change Displayed Data Through Data Validation?
Thank you. I'll play around with VBA and see if I can get it to do what I
need. "igorek" wrote: This can be done through VBA. you can write a procedure that will react on change cell value change. Once the change is made, copy the sheet from A to B. Regards Igor "TEK" wrote: I have 2 workbooks which we'll call A & B. Workbook A contains a dropdown box created through data validation which lists each month of the year. Workbook B contains 12 sheets, one for each month of the year with the data I need. What I'm looking to be able to do is select a month from the dropdown in workbook A and pull in the month's data from the appropriate sheet in workbook B. Can this be done automatically upon selection of the month, or does a procedure need to be written to handle the refresh? Any help would be much appreciated. |
All times are GMT +1. The time now is 09:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com