Thread: Sorting Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Sorting Help

Presumably, it doesn't work because the machine tabs are just a bunch of
formulae referring to the master tab.

That's the way it works I am afraid, you sort the cell contents, not
necessarily what you see.

--
__________________________________
HTH

Bob

"Smiles:-)" wrote in message
...
I have a workbook and I have a master tab and then a have a bunch of
machine
tab. When an order is entered on the master tab it is automatically moved
to
the appropriate machine tab. I am trying to sort of the machine tab and
it
won't let me but when I sort on the master tab it works and then my
machine
tab is also sorted. I need to be able to sort on my machine tabs. Can
anyone
help?

Thanks!