• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting two columns

P

Phuong Dinh

New Member
I have a listing of supplies that spans two columns. I need to sort the items in A & C alphabetically. Is there a way to automatically do this? (see spreadsheet)
 

Attachments

Hi Phuong,

I think filter will sort the data based on any one column, you can sort data either by Supplies or Supplies Cont.

Easy / One go solution:
As your list is continue on column C, you can copy column c to new sheet, then apply sorting. When data is sorted copy / past back :)

May be there is a vba / different solution by some other member.

Regards,
 
Khalid NGO said:
Hi Phuong,

I think filter will sort the data based on any one column, you can sort data either by Supplies or Supplies Cont.

Easy / One go solution:
As your list is continue on column C, you can copy column c to new sheet, then apply sorting. When data is sorted copy / past back :)

May be there is a vba / different solution by some other member.

Regards,
Click to expand...

Thank you for the reply. It's not the answer I hoped for, but it still works! I put the listing on Sheet2 and even added a column for "category". Now I can sort the the items by name or (for ease of gathering/packing the supplies) by category. On Sheet1, I just reference the cell order of Sheet2 :D

We don't update our list too often but when we do, it's a pain. Now I can change it quickly and easily. Thank you so much!
 
You must log in or register to reply here.
Back
Top