Macro copy text above

[Adilsec]

Copy text from rows below

Need help on excel

So i export my orders onto excel and use a macro to sort the order
The last step ,im finding difficult to code:

So on the custom label column if it’s blank i want to copy the cells below it.. if that makes sense.. up until the cells next to it are no longer blank
Sometimes a customer orders 3 things sometimes 2 sometimes 5 so that changes

Basically just want to combine orders onto one line,



Can any of you geniuses here solve it?

 

[Kaper]

I'm pretty sure, we can solve it. But your description of data layout (and needed output layout) is not very clear. So show the input data layout (and sample data - probably 10-15 rows will be enough) and expected output. You may use (recommended) XL2BB - Excel Range to BBCode or just post screenshot (remember to show where in a sheet (columns/rows) the data starts.