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.

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.

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.