| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the color of yellow tip box on data validation | Excel Discussion (Misc queries) | |||
| change the data validation to 'any value if 'other' is selected | Excel Discussion (Misc queries) | |||
| How does Data Validation change with a formula change? | Excel Worksheet Functions | |||
| How do I change the width of the data validation list box? | Excel Discussion (Misc queries) | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
Linear Mode
