Can I merge workbooks?

B

Bon Rouge

I have a couple of questions really :

First, can I merge workbooks? I have sheets in 6 different books an
I'm thinking about putting them together.

Second, can I put worksheets within a workbook in alphabetical order
It seems to be I have to move the worksheets to the right place? Am
wrong?

Actually, I have one more...
Does it matter, in terms of speed and system stability or whatever, ho
many sheets I have in one book?

Thanks for any help
 
B

Bon Rouge

I don't want to waste anyone's time...

I've just discovered that I can select all sheets and then copy them t
the end of a different book, so that's that one sorted.

(I'm new at this by the way)
 
D

Dave Peterson

I think you didn't get any responses because your first question was a little
vague. Merging can mean lots of different things to lots of people.

But now that you've figured out the first part <vbg>, here are a couple of
macros that may help sort your worksheets:

Chip Pearson's:
http://www.cpearson.com/excel/sortws.htm

David McRitchie's:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
D

Dave Peterson

And I don't like having too many worksheets in the workbook--but I don't split
workbooks up just because of the number of worksheets either.

So my answer is the larger the workbook, the slower it gets
(opening/saving/recalculation). I'm not sure about stablility issues.

I guess the question may be: How many worksheets do you think you need? And is
the stuff on the worksheets mostly formulas or mostly values?
 
Top