How do I combines data from multi-worksheets into one in ascendin

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a school project where I have entered alot of data into 3
worksheets and I need to combine them into one worksheet so that I may sort
them in ascending order, or keep the worksheet seperate and make all 3
worksheet in ascending order. I am only able to get one sheet at a time to
sort not all three. I have hit the ctrl button and clicked on all three
pages to combine them and it won't allow the sort. The problem is that the
info on pg. 2 and 3 needs to be filed into page 1 and vise versa in order to
get all the info in abc order. Any help.
 
Just copy and paste all the data into one worksheet and then sort it.

Hope this helps.

Pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining data from multiple worksheets into one 6
How to I combine excel worksheets? 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I combine multiple worksheets into one worksheet? 1
Match and combine multiple rows into one 1
VBA- Excel Programming:- 0
How can I combine several excel files into one? 1
combine columns of data from multiple worksheets into one 7

Back
Top