How to append/combine (not add) data in several sheets into one?

G

Guest

Assume that you have 100 sheets in an Xcel workbook which each has 10 rows of
data and you want 1 sheet with 1000 rows of data, what is the easiest way to
do it?

Is there an easier way to do it than cutting and pasting 99 times?
 
G

Guest

On the new worksheet, create a formula returning the value in the first cell
of the first worksheet, then copy paste ten rows down and however many
columns wide.

Copy the area you just pasted, go to the next empty row and paste. While the
new area is still selected Find/Replace (Ctrl+H) the name of the first
worksheet with the next worksheet name. Spelling counts.

Repeat until all data from the old worksheets appear on the same page,
highlight the entire page, copy/paste values and delete the old worksheets.


:
Assume that you have 100 sheets in an Xcel workbook which each has 10 rows
of data and you want 1 sheet with 1000 rows of data, what is the easiest
way to do it?

Is there an easier way to do it than cutting and pasting 99 times?
 

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

Top