Excel sorting.

[vbacoder12]

I have created an excel worksheet which is a combination of a power query and custom made excel columns. It seems like even though they are in the same sheet when I try to sort using one or another the colums don't stay with other.
Example column A is from the query. Column I is a custom row. If I sort column a all the data in row 1 won't stay together

 

[alansidman]

Please post a sample of your data in a third party platform, ie. Dropbox.com or Box.net. In this way we can see exactly the issue. I am guessing that the new column is not part of the table created by PQ and needs to be incorporated to that table.

 

[vbacoder12]

Please post a sample of your data in a third party platform, ie. Dropbox.com or Box.net. In this way we can see exactly the issue. I am guessing that the new column is not part of the table created by PQ and needs to be incorporated to that table.

I think i figured this out. I converted to range and then scripted a filter to go on the columns. I do have another question though related to vba. I some users which can run the macro n some that can't. I think it's associated with users not having access to tables used In the macro that I query. Anythoughts if it can't be anything else?