Amend VBA to append rows in multiple worksheets into one

[Starduzz]

Hi,

I'm trying to consolidate multiple worksheets into one specific worksheet and found the following VBA code:

Please Login or Register  to view this content.

However, i like to copy only rows from A9 onwards (instead of A1) in each worksheet and transfer the consolidated rows to a specific worksheet (starting from cell b6) in a specific workbook.

Is there any way to amend the vba code to follow the above scenario?

Appreciate your help and advice plse.

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...-into-one.html