Excel Tool to show daily, MTD and YTD data with ease
Budget: $10 – $30 USD
I have formulas in range K10:N13 that use a data validation list in I7 to change data from current month to previous month or YTD.
What I want is some sort of tool (maybe an active X control) that will let me change by day and still have the option of going from current month to previous month or YTD while still maintain the formulas. I am not sure how to accomplish this and would need some ideas.
What I want is some sort of tool (maybe an active X control) that will let me change by day and still have the option of going from current month to previous month or YTD while still maintain the formulas. I am not sure how to accomplish this and would need some ideas.