Copying Multiple Ranges with Macro
There is an Excel file that teaches how to perform the Copying Multiple Ranges with Macro operation.
Excel Source: Copying Multiple Ranges with Macro
This workbook copies multiple non-contiguous cell ranges simultaneously using VBA, with a 22-row numeric data table and Module1 code reference.
Hope it is useful.