For Loop to move Rows(B:D) Data to Single Column Consecutively. Code not working.

[unit285]

Hello,
This code has me all sorts of frustrated. It seems like it should work to me but it's not.

So what I want to accomplish is to move data from the mod sheet to the Final Sheet. Specifically, Columns (B:D) data on each populated row in the mod sheet. So for example, currently, the value in mod sheet B2 should move to the Final Sheet A2, the value in mod sheet C2 should move to the Final Sheet A3, and the value in mod sheet D2 should move to the Final Sheet A4, Then it should move to mod sheet row 3 and repeat and on and on.
My code is posted below, Any help is greatly appreciated!

Please Login or Register  to view this content.

[xladept]

Just a small change:

Please Login or Register  to view this content.

[CK76]

Your code as it's written will replace entire range's value each time.

My preference is to use array to do operation in memory and commit to cell in 1 shot.

Please Login or Register  to view this content.

[xladept]

You're welcome and thanks for the rep!