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!