Hi Mr Excel Community,
I am trying to sort data using VBA.
The idea is to create a Macro for different users. The problem is that each users gets the same data but the columns order is different.
So the first step is to arrange the data in the same way for different users.
I would like to pass the data to an array then move array columns? is that possible? or create an array and start passing the data based on a fixed columns criteria?
I am sure that there are different ways, just trying to understand which is the best.
I was wondering if anyone has some code or have seen anything that could help me/guide in this process.
Thanks
I am trying to sort data using VBA.
The idea is to create a Macro for different users. The problem is that each users gets the same data but the columns order is different.
So the first step is to arrange the data in the same way for different users.
I would like to pass the data to an array then move array columns? is that possible? or create an array and start passing the data based on a fixed columns criteria?
I am sure that there are different ways, just trying to understand which is the best.
I was wondering if anyone has some code or have seen anything that could help me/guide in this process.
Thanks