Forum Discussion

Tcamp2480's avatar
Tcamp2480
Copper Contributor
Jun 08, 2022

YTD Referencing a data validation list- Automated

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

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Tcamp2480 

    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.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources