I'm trying to do some very simple, or so I thought 
I'm trying to use "sort ascending" for column A but either the sort doesnt take column B with it, or it sorts using column B - see attached.
Note: This list will be constantly added to and sorted into product ref numerical order.
Any ideas?

I'm trying to use "sort ascending" for column A but either the sort doesnt take column B with it, or it sorts using column B - see attached.
Note: This list will be constantly added to and sorted into product ref numerical order.
Any ideas?
Comment