YTD Referencing a data validation list- Automated

New Contributor

I am trying to create a report. That shows YTD totals that references based on the month. For example I select March the formula will auto auto adjust that data to show Jan-march for whichever year.

2 Replies


I don't understand exactly on which area you want to do something, but here is a small example that might help you.


With your permission, if I can recommend you, add a file (without sensitive data) or photos to your project.

Explain your plans in relation to this file/photo. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone :).


* Knowing the Excel version and operating system would also be an advantage.


Hope I could help you with these information / file.



I know I don't know anything (Socrates)

@NikolinoDE thank you. Good Idea I will upload one.