Forum Discussion

Magnus82's avatar
Magnus82
Copper Contributor
Jan 07, 2019

Cell sorting Excel

Hi,

I need to sort these cells from left to right and continue the rows below, same order as the red numbers.

It's the second line in the cells that I want to sort, the QJ numbers.

The red numbers don't need to be in order and I don't want to separate/remove the red numbers from their cells.

How do I do this?

Thanks.

  • JWR1138's avatar
    JWR1138
    Iron Contributor

    Do the red numbers need to be sorted with the QJ numbers or can they just stay in sequential order as they are currently? I'd like to take a stab at this, it's going to be a VBA solution though. Can you post the excel file of the screenshot you uploaded?

Resources