Push data to the right of a range of cells

Hey,

I have a large datasheet which has some columns where the data needs to be pushed to the right of a range of cells, the example attached should be clear enough I don't know how to make it easier to understand because it's pretty easy anyway just one of those extremly repetitive tasks if done manually

See attachment

Thanks in advance
- Hyflex

@watersev, that's a great macro. As a general teaching tip to others, be sure to declare the variable type for all the variables:

Please Login or Register  to view this content.

Separately, purely as a personal preference for "readability", I'd suggest not using single letter variables, especially not a bunch. Doing it does create some pretty awesome smart-looking code, but novices will really have trouble reading it. Why not indicate in your macros what the variables all do, like you did with "data" and "result" and "row_count"?

Please Login or Register  to view this content.