Copy Multiple Sheets with VBA
I was asked during a webinar recently how you send multiple worksheets to a new workbook in a batch. I was pretty sure this information would be on my site but a quick search of my site did not reveal any joy.
I put together a simple file which sends an output sheet and two source data sheets to a directory saves it then starts the process again after changing a unique identifier. The process is a little more in-depth than sending just one sheet but there is not a great deal more code involved.
Read MoreFeatured Posts
Recent Posts
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022
Cascading Combo Boxes 3 and 4 Layer April 24, 2022