Pulling for multipul work sheets into one master work sheet

**boll55** · 02-08-2013, 11:31 AM

I have a work book with prob close to a thousand individual work sheets in it. I have a goup of cells that are the same in ever work sheet that I would like to pull and place into a master work sheet. I dont want to copy and paste each one, I'd be a hundred before I finished and I dont have that kind of time. Im thinking a macro might be what I need but Im not very good with useing them let alone making one to fit me needs.

Any help would be so much appreciated.

Thanks

http://www.mrexcel.com/forum/excel-q...ml#post3387761

http://www.ozgrid.com/forum/showthre...204#post648204

**K m** · 02-08-2013, 11:46 AM

You need to post an example worksheet

**Fotis1991** · 02-08-2013, 11:50 AM

Does Jerry's suggestion helps you?

https://sites.google.com/a/madrocket...ets-to-1-sheet

**boll55** · 02-08-2013, 01:46 PM

Ok than works kind of but i need it modified and i cant do that.....

the data i have is in cells L4 through R4....

Can you help me

**Fotis1991** · 02-08-2013, 02:40 PM

ok. You are welcome. No need to thank me..

Maybe if we have a sample workbook...

**boll55** · 02-08-2013, 03:57 PM

Santa.xlsx

here you go

**K m** · 02-08-2013, 04:32 PM

Look at the attached workbook.

I added a couple of blank worksheets that I labeled 1 and 2, I added a summary worksheet and move the Violation code to its own worksheet

Maybe this is what you had in mind