G
Guest
I am trying to figure out how to create a macro that will add a row in the
proper place everytime. For ex. I have rows with months inputted. Every month
i would like to insert a row after the last month(A20) on the sheet and
insert the "next month"(A21) and then input data across the inserted row. The
problem then becomes the next month if I run the macro it will insert in a
new row after A20 when I need the row inserted after A21. Is there a way for
excel to know to go to the last Month in the row and insert a row.
proper place everytime. For ex. I have rows with months inputted. Every month
i would like to insert a row after the last month(A20) on the sheet and
insert the "next month"(A21) and then input data across the inserted row. The
problem then becomes the next month if I run the macro it will insert in a
new row after A20 when I need the row inserted after A21. Is there a way for
excel to know to go to the last Month in the row and insert a row.