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!

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!

Is there a way then to make the cells on the Machine tabs to in a way loss
the formula once they are sent from the master tab?

"Bob Phillips" wrote:

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!

You say the data is sent automatically so you must have code written to do
that.

Add a pastevalues to your code.

Selection.PasteSpecial Paste:=xlPasteValues

Or don't copy/paste just set the values

Range("K43").Resize(10, 10).Value = _
Worksheets("Sheet2").Range("A1:J10").Value


Gord Dibben MS Excel MVP

On Thu, 4 Sep 2008 02:35:01 -0700, Smiles:-)
wrote:

Is there a way then to make the cells on the Machine tabs to in a way loss
the formula once they are sent from the master tab?

"Bob Phillips" wrote:

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!