Swapping Col based on the Header

  • Hi guys,


    I am trying to find a way to organize the columns of my sheet in ascending order, these columns are a mix of week/year and month/year and they are dynamic, changing every week. I could use the code below, but the problem is when the header changes the code stop working. Any suggestion?



    StockDesPO/LineQty2320202420203020203120202620202520202720201/08/20201/09/20201/10/2020



  • You need to understand that the Forum Rules require you use Code Tags when posting code to the Forum.


    You have been warned in the past about the rules- Code Tags, cross posting. If you don't follow the rules then expect your posts to be closed.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!