VBA/Macro to Combine worksheets in a workbook into 1 sheet

Neavalmi

New Member
Joined
Jun 14, 2009
Messages
38
Hello Excel Experts:

I have search this forum before i made a new post since none of the threads is exactly working for my problem.

I have an excel file which contains costed bills of materials (BOM) of products, each worksheet is named by its SKU/model number.

My data has consistent/fixed columns from A to R
Data starts from row 41 (with headers) , 42 without headers. Some data are within rows 1 to 40 but these should be ignored.
Row numbers vary per worksheet

Appreciate your help to copy and paste/ combine all BOMs data into a separate spreadsheet in the same worksbook.
The headers for the second and succeeding worksheets need not to be copied.

also, the worksheet name must be copied in the last column "S" so i can know where is the data is coming from which worksheet.

The format of each worksheet should be carry over , not paste values. (rows are color coded by the levels in the BOm)

Thank you very much for your help guys.

Regards,
Nea
 

Forum statistics

Threads
1,085,495
Messages
5,383,997
Members
401,871
Latest member
allemandi

Some videos you may like

This Week's Hot Topics

Top