how do I combine multiple worksheets into one? not summarize

G

Guest

i have multiple worksheets from the 'old' XL that max at 65k rows. i want to
combine all of the data into one worksheet using the new XL that allows 1mil
rows of data. from there I will manipulate, make changes, then create pivots
and charts.
 

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

How do I combine multiple worksheets into one worksheet? 1
Combining like worksheets into a single worksheet 2
Combine several spreadsheets with multiple worksheets into 1 file 5
How do I combine worksheets w/o enough rows to combine? 3
How do I combine worksheets 2
combine multiple workbooks? overcome 255 character limit? 3
combine columns of data from multiple worksheets into one 7
how do i combine excel worksheets 1

Top