Consolidating Multiple Worksheets to one

Hi,

Hoping someone could help me with this - been trying to find some solutions online but can't seem to get them to work

I'm looking for a code that would consolidate the information I have in my three sheets titled "Raw" into the Summary sheet. I will have other sheets in the workbook, but only want to consolidate those three. They will all have the same header.

Could someone please help! Much appreciated!

Thanks!

Pho6

Try the attached.

Hello sir, try this out in a blank module

Please Login or Register  to view this content.

Poizhan,
Good codling, but spoiled it with unnecessary selection

Please Login or Register  to view this content.

Originally Posted by AB33

Poizhan,
Good codling, but spoiled it with unnecessary selection

I always use selection now with copy/paste from sheet to sheet, for some reason on my machines copy/paste will randomly throw 1004 errors.

No, you rarely need to use "select". It does not server anything, except adding overhead to a code. The only place for selection is on recorded macro.

Originally Posted by AB33

No, you rarely need to use "select". It does not server anything, except adding overhead to a code. The only place for selection is on recorded macro.

Roger that :D

Wow thanks everyone for all of your help!!

Poizhan or Ab33 - how would I change the code if I wanted to be pasted starting a certain line in the Summary sheet? For example, in my actual summary, sheet the header actually starts on row 9 and not row 1.

Thanks!!!

Header row 9 and data starts in row 10
Both codes attached.

Hey AB33 thanks for the code - it's not working for some reason though - can't get the data to paste on row10 on summary sheet. Any ideas?

Change the single line from

NR = 2

to NR=10

Thanks so much for the code! Works now! :D Much appreciated!