Combine all worksheets into a single worksheet in a new workbook

**ajm1949** · 04-01-2012, 10:25 PM

I have the following code to copy one sheet at a time to a "master" worksheet (Toyota") in the same workbook

What I need to do is copy all worksheets onto a single worksheet in a new workbook (only rows with data in column A)

In this example "RAV4" is the source sheet

Please Login or Register  to view this content.

Thanks in advance

Alan

**Trebor76** · 04-02-2012, 12:38 AM

Hi Alan,

So just to clarify - you want to create a standalone Excel file for each and every tab from the workbook where the macro is run?

Robert

**ajm1949** · 04-02-2012, 01:26 AM

Hi Robert

Yes you have the right idea. Every tab in the workbook should be combined into one worksheet (tab) in a new workbook

Cheers

Alan

**Trebor76** · 04-02-2012, 01:56 AM

Not sure if you've really answered the question, but we'll see after you run this I suppose:

Please Login or Register  to view this content.

Robert

**ajm1949** · 04-02-2012, 02:32 AM

Hi Robert

I guess I didn't explain quite well enough.

Data from each worksheet should be copied underneath the previous one(omitting any rows with any empty cell in column A) so the end result is a single workbook with one tab containing all the data from the source file.

My original code does this one sheet at a time but I have to change the name of source sheet in the code and run it again for every sheet.

It also puts all data on the "Toyota" tab in the same workbook but this is not a big issue. A separate workbook would be nice but not necessary

I hope this makes it a bit clearer. See also attached sample file

Alan

**Trebor76** · 04-02-2012, 02:59 AM

OK - I think (hope) I have it now:

Please Login or Register  to view this content.

HTH

Robert

**ajm1949** · 04-02-2012, 03:07 AM

Hello Robert

That works perfectly

Many Thanks

Alan

**Trebor76** · 04-02-2012, 08:20 AM

Hi Alan,

Glad to hear it and you're welcome.

Thanks also for adding to my reputation

Regards,

Robert

Combine all worksheets into a single worksheet in a new workbook

LinkBack

Thread Tools

Rate This Thread

Display

Combine all worksheets into a single worksheet in a new workbook

Re: Combine all worksheets into a single worksheet in a new workbook

Re: Combine all worksheets into a single worksheet in a new workbook

Re: Combine all worksheets into a single worksheet in a new workbook

Re: Combine all worksheets into a single worksheet in a new workbook

Re: Combine all worksheets into a single worksheet in a new workbook

Re: Combine all worksheets into a single worksheet in a new workbook

Re: Combine all worksheets into a single worksheet in a new workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions