I have a range of columns. Starting at Column C to AA. Each Column header is based an Calendar month This year and last year with a total at each end.
I would like in Row 5 to Mark an "X" value in each Cell that I want to Keep and blank on any other that will update each month.
For Example
If I select Jan-2021, I want mark row 5 with an " X" in Columns Jan-2021, Dec-2020, Nov-2020, Oct-2020 and Jan-2020
If I select Feb-2021, I want mark row 5 with an " X" in Columns Feb-2021, Jan-2021, Dec-2020, Nov-2020 and Feb-2020
If I select Mar-2021, I want mark row 5 with an " X" in Columns Mar-2021, Feb-2021, Jan-2021, Dec-2020 and Mar-2020
If I select Apr-2021, I want mark row 5 with an " X" in Columns Apr-2021, Mar-2021, Feb-2021, Jan-2021 and Apr-2020
If I select May-2021, I want mark row 5 with an " X" in Columns May-2021, Apr-2021, Mar-2021, Feb-2021 and May-2020
If I select Jun-2021, I want mark row 5 with an " X" in Columns Jun-2021, May-2021, Apr-2021, Mar-2021 and Jun-2020
In a nut shell, Based on my selection, mark an x on that selection and the previous three months and the same period last year.
This will be used to hide the columns that have no "X" in place (I already have the code).
It doesn't necessarily need to be done in a VBA code. A formula can work as well. I just don't have any ideas. Can you GUru's help?
Thank you!
I would like in Row 5 to Mark an "X" value in each Cell that I want to Keep and blank on any other that will update each month.
For Example
If I select Jan-2021, I want mark row 5 with an " X" in Columns Jan-2021, Dec-2020, Nov-2020, Oct-2020 and Jan-2020
If I select Feb-2021, I want mark row 5 with an " X" in Columns Feb-2021, Jan-2021, Dec-2020, Nov-2020 and Feb-2020
If I select Mar-2021, I want mark row 5 with an " X" in Columns Mar-2021, Feb-2021, Jan-2021, Dec-2020 and Mar-2020
If I select Apr-2021, I want mark row 5 with an " X" in Columns Apr-2021, Mar-2021, Feb-2021, Jan-2021 and Apr-2020
If I select May-2021, I want mark row 5 with an " X" in Columns May-2021, Apr-2021, Mar-2021, Feb-2021 and May-2020
If I select Jun-2021, I want mark row 5 with an " X" in Columns Jun-2021, May-2021, Apr-2021, Mar-2021 and Jun-2020
In a nut shell, Based on my selection, mark an x on that selection and the previous three months and the same period last year.
This will be used to hide the columns that have no "X" in place (I already have the code).
It doesn't necessarily need to be done in a VBA code. A formula can work as well. I just don't have any ideas. Can you GUru's help?
Thank you!