Excel VBA how to copy multiple sheets multiple times

Опубликовано: 24 Февраль 2026
на канале: Strategize Financial Modelling
4,047
26

This video will present one way to copy selected worksheets, multiple times in a workbook.

This example workbook contains three sheets for an income statement, balance sheet and forecast.

Sure we can manually copy the selected sheets once using Excel's native features. However, we will apply an approach using Visual Basic, in order to copy these selected sheets multiple times.