I have an excel workbook with 19 sheets. Sheets 2 thru 19 pull data from sheet 1 (A6:A35). Is there way to sort all 19 sheets (A6:AA35) so the data stays aligned? Also, just to add a further twist, sheet 1 (A6:A35) has some "0" value cells which I don't want to be included in the sort (essentially they should stay at the bottom of the sort).
Solved by O. J. in 23 mins