Hi all
I want macro to auto fill the 4 quarter when type one month of previous quarter in A2
For examble
When I type in Cell(A2) = 202012 or 202011 or 202010, Cell(A3) autofill = 202009, Cell(A4) = 202006, Cell(A5) = 202003, Cell(A6) = 201912
When I type in Cell(A2) = 202009 or 202008 or 202007, Cell(A3) autofill = 202006, Cell(A4) = 202003, Cell(A5) = 201912, Cell(A6) = 201909
When I type in Cell(A2) = 202006 or 202005 or 202004, Cell(A3) autofill = 202003, Cell(A4) = 201912, Cell(A5) = 201909, Cell(A6) = 201906
When I type in Cell(A2) = 202003 or 202002 or 202001, Cell(A3) autofill = 201912, Cell(A4) = 201909, Cell(A5) = 201906, Cell(A6) = 201903
I attachment file with result that I want, please help me to do this with VBA code.
Thanks./.
Bookmarks