Forum Discussion
AUTO POPULATING CELLS USING A DROP DOWN LIST
On sheet 1, I have a column with all the months of the year. I made a dropdown list of those months. When I select from the drop down list, any month, I want to auto populate the prior 3 months into ...
It's an intriguing problem, and very solvable. You sound like you're very competent, so I'm just going to point you in a different direction and challenge you to resolve it.
Here's my advice: stop thinking of backing up the list (the list that names the months) three months. Start thinking just of numbers, specifically numbers 1 through 12. And then investigate the MOD function.
You'll find that If you enter any number 1 through 12 in cell A1, this function will yield the number of the month 3 months prior.
=MOD(A1-3,12)
From that, it should be child's play to convert that starting number to the numbers (and then the names) of the three prior months.
Thank you so much for calling me competent. In all honest though, a week ago, all I knew how to do was =SUM haha. I just dove deep into research and figuring things out(Thank God for YouTube and the internet) I don't know anything about the MOD function, but just like with the INDEX and MATCH functions, I will do my research and figure it out. Thank you for the help.