G GRG Apr 14, 2010 #1 I would like to combine several spreadsheets and then do a sort of both of them. Is this possible.
J JLatham Apr 14, 2010 #2 Do you mean several sheets within one workbook (.xls file) or do you mean sheets that are currently in multiple workbooks? I ask because often people use one term when they mean the other, we give them an answer and it turns out to be wrong. For 'sheets' you might look at http://excel.tips.net/Pages/T003005_Condensing_Multiple_Worksheets_Into_One.html or http://www.vbaexpress.com/kb/getarticle.php?kb_id=151
Do you mean several sheets within one workbook (.xls file) or do you mean sheets that are currently in multiple workbooks? I ask because often people use one term when they mean the other, we give them an answer and it turns out to be wrong. For 'sheets' you might look at http://excel.tips.net/Pages/T003005_Condensing_Multiple_Worksheets_Into_One.html or http://www.vbaexpress.com/kb/getarticle.php?kb_id=151