VBA to fill many ranges of empty cells in columns A and B with different cell values

[Armien7]

I hope everyone is having a wonderful new year so far. I'm really struggling with a macro I'm trying to build and I hope I can get some advice here

I have a sheet (called: "Motors") with 24720 rows. I'm trying to fill empty ranges with different intervals in column A and B with the values of the last filled cells of each range in column A & B. So for example: Range (A16, B16 and C16 : A27, B27 and C27) is empty, and I want to have it filled with the cell values of A15, B15 and C15, etc. Since I have 20.000 rows+, it takes a lot of time to do it manually.

The big problem I have is that each empty range differs from the previous one (one may containt more empty rows than the other one). For clarification I have made the following screenshots:

Hopefully I can get some tips and new insights

Best regards,
Armien

 

[Armien7]

Very weird, same problem (the macro does run tho). It fills the first empty range, but stopt there, doen't copy Cells A28, B28 and C28 to the next empty range (which in this case is to ABC:123), but of course the interval of the next empty range where ABC:124 should be pasted in differs.

 

[Fluff]

If it's not copying down that suggests the cells aren't actually empty. You will need to find out what's in them.

 

[Armien7]

If it's not copying down that suggests the cells aren't actually empty. You will need to find out what's in them.

O wow you are totally right, I haven't thought of that for one second! I tried the macro in a new test sheet and it works perfectly! Thank you so much for your help Fluff, this truly made my day! I only need to find a way to "Delete" all "empty ranges" in a efficient way. Do you have a last small tip for this?

 

[Armien7]

O wow you are totally right, I haven't thought of that for one second! I tried the macro in a new test sheet and it works perfectly! Thank you so much for your help Fluff, this truly made my day! I only need to find a way to "Delete" all "empty ranges" in a efficient way. Do you have a last small tip for this?

Nvm filter and delete lol. It works totally fine! Again, thank you so much

 

[Fluff]

Glad to help & thanks for the feedback.