Combine Selected Columns & Rows Informations from Multiple Excel Sheets to one sheet

Dear all,

I need t combine two excel sheet in one, the second sheet contain details to be added into the 1st one by creating a new sheet.

It's possible to do it with simple formulas, but I want it with VBA so it will be more easier to use when I have different level of details to be inserted and Thousands of activities.

Please find attached the Excel file to explain more what I want to do.

Thank you in advance.

Regards.

Hi,akherief

try this

Hi Simcode,

thank you a lot, it's works well.

Thank you.

Then,mark the thread SOLVED pls.
& u r welcome.