Can I Change Displayed Data Through Data Validation?

T

TEK

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.
 
I

igorek

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top