Copy paste values from sheets into one master sheet

**nickmax1** · 03-20-2013, 09:03 AM

I need a looping code that copies and pastes data from each sheet in a workbook to the bottom of the sheet called "Data", then move on to the net sheet and repeat the process.

Here is what I have so far, but the code just loops the Data sheet, rather than ignore the data sheet!

Please Login or Register  to view this content.

**AB33** · 03-20-2013, 09:26 AM

Please find attached

**nickmax1** · 03-20-2013, 09:36 AM

AB33 you are a legend.

I deleted the

Please Login or Register  to view this content.

as I want to continually add to the data spreadsheet with more and more, so I didnt want that to be erased every time i ran the macro .... thanks!!!

I have found a problem....
With your code that identifies the last row of data, i have noticed that in my data at times I may have hundreds of blank rows then randomly there will be a "0" or something. Your code looks for that and therefore copies all those blank rows to the data sheet. How can I overcome this?

Solved with this addition

Please Login or Register  to view this content.

**AB33** · 03-20-2013, 10:08 AM

In which column are the blank rows? I can include few lines to delete them

**nickmax1** · 03-20-2013, 10:26 AM

thanks AB33 - solved it with this addition to your code:

Please Login or Register  to view this content.

**AB33** · 03-20-2013, 10:31 AM

Nick,
Great!
That was about going to suggest. Instead of looping through each row in each sheet to identify blanks, it would be efficient to do on a summary sheet.
Sorry for not helpful with your earlier request?