Sorting Help

[Smiles:-)]

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!

 

[Bob Phillips]

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.

 

[Smiles:-)]

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?

 

[Gord Dibben]

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