TWW isn't the only resource I'm using to figure this out, but any help would be appreciated.

I've got a lot of separate excel spread sheet files, and I want to merge them into one file, with each of those original files occupying one tab each. Is this possible?

I'd also like to do something similar with Word files, can you merge a few documents without page breaks?

[Edited on November 11, 2008 at 11:41 AM. Reason : I have no clue how I double posted a thread, mod please delete the other one.]

11/11/2008 11:39:59 AM

yes, it's easy. When you have multiple workbooks open, you can just right click on any of the worksheet names (the tabs) and select "move or copy", then you'll be given the chance to copy (or move) the worksheet into any other open workbook.

are you looking for an automated way to do this? or just asking if it's possible?

11/11/2008 11:43:00 AM

Thank you! Not sure if automated is what I want (or if its even possible) but this is helpful.

11/11/2008 12:08:09 PM

well, it depends on how many you have to combine, or how often you have to do this.
If this is a one-time thing, and you have < a couple dozen spreadsheets to combine, than doing it this way (manually) is just as good.

But if, for example, you had to do this on a regular basis, or if you have 50+ workbooks to combine, then a little VBA magic would be in order.

11/11/2008 1:10:05 PM

VBA magic?

I don't get it. Also, apparently what I asked for isn't getting the job done as I need it to

11/11/2008 11:50:47 PM

by "VBA magic" I was referring to writing some Visual Basic code, which is a platform that is built into Excel, that can help accomplish repetitive tasks. Obviously me or someone else here would have to actually write the VBA.

If what I mentioned in my first post does not solve your problem, then I do not fully understand the question.
check your PM, and you can send me an email with some of the spreadsheets and I'll take a closer look at what you're trying to do

11/12/2008 12:13:34 AM

agentlion is referring to macros, you've probably heard those referenced if you haven't heard of VBA.

11/12/2008 9:00:22 AM

download asap utilities. (asap-utilities.com)

it's an excel add in that makes excel do everything you think it should already be able to do. i've been using it for years and years and years.

11/12/2008 9:17:17 AM