macro copy all sheets information in 1 sheet

[arn0ldas]

hello everybody i need some help

i have this VBA code but i need some help white changes. this macro copy all sheets information in 1 sheet (new one)

1)but i need copy not all sheets information i need copy jest specific sheets witch name its - ACTONA - BXC - WEHKAMP
2)i need copy not all colums but jest from colum A to colum O
3)i need copy not from 1 row but from row 5

cann i find her HELP for me ?

Please Login or Register  to view this content.

[oeldere]

Please add an excel file, without confidential information.

Please also add the desired result.

[arn0ldas]

hello i add excel file whit information
1) yellow color sheets - source sheets for desired result
2) red sheet desired result (in this sheet i don't need formulas jest value from source sheets)

i hope its will be help

[oeldere]

The code below will take all information of the yellow sheets and put it in the consolidated sheet.

See the attached file.

Please Login or Register  to view this content.

[arn0ldas]

its excellent but for me its one minus in this macro
1) its coping all data in worksheet but like you see sample i need copy in table in that worksheet

that impossible ?

and i want say big Thanks! for you for helping me

[oeldere]

See the new file.

You have to code (change) the headers.

Please reply.

Please Login or Register  to view this content.

[arn0ldas]

amazingly. i will check on my original file but i see now its very good Thank you friend. I owe you one

[arn0ldas]

I have a question. or you can could do the same thing between different workbooks ?
should be as
workbook-1 (Consolidated - Scheat)
workbook-2 (Source - Scheat)

[oeldere]

That's a job for other persons.

You could find examples of that also on this forum.

[arn0ldas]

well i look for. thanks