Fill cells between values

Hi, in my workbook I have a sheet called "DATA" where users copy over data from a database into range B:X. The row depends on where the previous data ends. In column A the Month name is put in the first row of the added data and the last row of the added data due to the formatting from the source. I need to have a macro fill in the blank cells in column A between the two cells that already have the month.

For example, if someone pastes data into cells B1:X55 where A1 is "JULY" and A55 is July. I need a macro to fill A2:A54 in with the same value automatically.

Any help is appreciated.

Upload a sample file depicting your scenario to make use of please...

Your file that you have uploaded has no depiction of what you want...
This is my understanding...

Please Login or Register  to view this content.

Your attached file does not show a before and desired result sheet, so this is only a guess, but maybe.

Please Login or Register  to view this content.

Using Power Query, here is the Mcode for your file. If you are unfamiliar with Power Query, click on the links in my signature.

Please Login or Register  to view this content.