Importing Data from Multiple Worksheets starting with the Same Name

**Saarang84** · 08-08-2010, 01:27 AM

Hi,

I've a macro in which there are various sheets namely Extract, Rule List, New, Existing.

I generate 2 worksheets from the Extract sheet - these worksheets start with the name "Samples_xx" where xx denotes a number - the no. of filled rows in the sheet.

All that i need is to consolidate the data found in the sheets that start with the name "Samples_xx" into a single worksheet named Master in the same workbook. The sheets "Samples_xx" both are in the same format - they contain same no. of columns.

Here's the code:

Please Login or Register  to view this content.

Sarang

**foxguy** · 08-08-2010, 01:24 PM

Please Login or Register  to view this content.

**JBeaucaire** · 08-08-2010, 07:51 PM

Here's how I would write your macro, similar to foxguy's idea:

Please Login or Register  to view this content.

**JBeaucaire** · 08-08-2010, 10:46 PM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

**Saarang84** · 08-11-2010, 05:05 AM

Hi Jerry,

The macro works fine.. But this code does not work if there is a line break (in the sense that there is an empty row inbetween). That's the one thing i want to be taken care of... How can that be done??

Sarang

**JBeaucaire** · 08-11-2010, 09:42 AM

The macro does not care about line breaks, or at least I cannot see any reason blank rows would make the macro "not work", it should still copy all the data from all the sheets to one sheet, blank rows in between included.