P
PatG
I receive a monthly spreadsheet from another department that I re-sort by
product numbers using a custom sort list.
Recently one of the product numbers was not being recognized so it would be
pushed to the end of the list every time. It also was not recognized when
running a macro.
I found that by "clearing" the cell and re-typing the product number fresh,
it will get picked up and appear at the correct place on the list after
sorting.
(NOT deleting, or cut/pasting or copy/pasting or paste-special value only
none of which work)
This month 4 new product numbers are doing the same thing...so now I clear
them and then retype them too.
The 5th new product number WILL NOT FIX even after I clear it and re-type
it. It is in my custom list in the correct place, but when you refresh the
sort it goes back down to the bottom.
Using Excel 2003
HELP! I have wasted a lot of time on this.
product numbers using a custom sort list.
Recently one of the product numbers was not being recognized so it would be
pushed to the end of the list every time. It also was not recognized when
running a macro.
I found that by "clearing" the cell and re-typing the product number fresh,
it will get picked up and appear at the correct place on the list after
sorting.
(NOT deleting, or cut/pasting or copy/pasting or paste-special value only
none of which work)
This month 4 new product numbers are doing the same thing...so now I clear
them and then retype them too.
The 5th new product number WILL NOT FIX even after I clear it and re-type
it. It is in my custom list in the correct place, but when you refresh the
sort it goes back down to the bottom.
Using Excel 2003
HELP! I have wasted a lot of time on this.