Re: sort on separate sheet
I live in Louisiana, USA so it is Central time zone -6 GMT.
Well, the xlpastevalues should only paste values and not do anything with the formulas. Perhaps someone else with excel 2010 can debug it? I have 2007 and it works a charm for me haha.
Here is what I would do for formatting, if you want it the same for both. Right click s1 tab and click copy, it should create a new sheet called s1 (1). Just delete s2 and rename s1(1) to s2. It will be an exact copy of s1. Then clear out the data from rows 3 down... just select them and press delete (do NOT right click and delete or else this will remove formating too). Not sure if the conditional formats will transfer.
It is possible to remove J, K, and L from the process but would be easier if you just hid those columns. If you truly need them removed, let me know and I'll work on it.
Are the zero's formulas? How are they formatted? Descending order should put numeric zeros at the bottom of the list.
Robert D. Specian Jr.