Forum Discussion
Someone help me!!!
Hey people, i'm doing a weekly report to keep track of what my employees spend and i'm having an hard time..
On the same worksheet I want to include all the weeks from this year and be able to navigate between weeks.
For example: If I click on any week (semana in portuguese) I want to load another table.
Sorry for my english.
Help!!!
I think you can just have a look up for your drop down. i.e. dropdown value in column A, Start Date in Column B. End Date in Column C. Then when you change the drop down two cells will change to the correct dates. These two dates can then be incorporated into the criteria for your formula in the data table. (Please see attached file for reference)
Something like this:
Please let me know if this helps or if you need further guidance if the attached file doesn't solve your issue.
