Hello All,
Attached is a sample sheet of the task i am working on presently.
I have two worksheets(presentation and data) in my workbook(sample sheet).
I need the drop down and scrollbar tools to determine the data that will be extracted from the Data worksheet.
The Scrollbar represents the different weeks Week1 to Week 5, while the Drop down menu is for selection of Year.
I tries using the index and match formula but i am in a fix.
Any assistance rendered will be highly appreciated.Thank you.
Thank you
Attached is a sample sheet of the task i am working on presently.
I have two worksheets(presentation and data) in my workbook(sample sheet).
I need the drop down and scrollbar tools to determine the data that will be extracted from the Data worksheet.
The Scrollbar represents the different weeks Week1 to Week 5, while the Drop down menu is for selection of Year.
I tries using the index and match formula but i am in a fix.
Any assistance rendered will be highly appreciated.Thank you.
Thank you