If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|