V Vera Jul 13, 2003 #1 I need to sort 12 sheets (List of Names) all together in the same work book. Is There a way to do This? Thank you! Vera
I need to sort 12 sheets (List of Names) all together in the same work book. Is There a way to do This? Thank you! Vera
D Dave Peterson Jul 13, 2003 #2 Depends on how much data you have in all 12 sheets. If the grand total is less than or equal to 65536 (number of rows in a worksheet), then you could add a new worksheet, copy each of the twelve sheets' data to that new sheet and sort that.
Depends on how much data you have in all 12 sheets. If the grand total is less than or equal to 65536 (number of rows in a worksheet), then you could add a new worksheet, copy each of the twelve sheets' data to that new sheet and sort that.