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 ...
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.
As variant
in A8 it could be
=UPPER(TEXT(DATE(Sheet1!$H$1,MONTH(1&Sheet1!$S$1)+8+ROW()-ROW($A$7),1),"mmm"))and drag it down to next two cells