Ask a new question

Sorting data in multiple worksheets

I converted a PDF file to an Excel 2003 workbook. The excel file has 142 worksheets. I need to sort the data. Is there a way other than copying worksheets 2-142 (one at a time) to the end of sheet #1 to sort all the data in the workbook?
Answer
Answer
Probably...but, it depends on the structure of the data in the 142 sheets.

If it's set up like a database table (column headings at the top, data rows below the headings, same headings on all sheets) there are ways to consolidate the data. Can you describe your data structure?
Best regards,

Ron Coderre
Microsoft MVP - Excel (2006 - 2010)

P.S. If any post answers your question, please mark it as the Answer (That way it won't keep showing as an open item.)
Regards,

Ron Coderre
Former Microsoft MVP - Excel

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 1,618 Applies to: