Copying data from multiple sheets to master sheet

**phong919** · 01-13-2010, 12:15 PM

Hello all,

I'm trying to achieve the following and was wondering if anybody can give me some guidance.

i have 1 workbook, and within the workbook i have about 51 tab sheets. The first tab sheet is the master sheet. My objective is to copy multiple rows across 51 sheets. i was wondering what would be the best way in doing so? i've attached a sample of the work book. If you look at the master sheet i've copied one row from sheet 1 to the master sheet. i would like to start copying from row 29 until the end of that section and then start copying the next section. I'm not sure how this can be done.

**StephenR** · 01-13-2010, 01:23 PM

It would make life a lot easier if you could order the columns in the master sheet the same as in the other sheets. Then you could do straightforward copy and paste.

**phong919** · 01-13-2010, 01:56 PM

i can do that. do you have a sample code for that? i can make the adjustment once i figure out what the code looks like.

thank you.

**StephenR** · 01-13-2010, 02:05 PM

Is it only the orange cells that need to be copied? I have to say that your spreadsheet is not laid out as efficiently as it might be. Blank rows are not advisable. Oh, and you need to ditch those merged cells. They also make life difficult.

**phong919** · 01-13-2010, 02:19 PM

oh i know. i did not do the spreadsheet. it was giving to me. it's the manager. they drive me crazy.

Yes it's the orange cell that needs to be copied over to the master sheet. i'm guessing i need a loop to go through the rows to copy? and also the section on the bottom after the cell "26. responsible area". just all the rows. i'll have to speak to the creator of the spreadsheet.