Excel Create Child Sheets From Master
Recently my friend in Tasmania – Valerio – was kindly helping someone online (the kindness of strangers). The problem was as follows. The person had a master list and wanted to create child sheets from this master list. Sort of a parent to child type exercise where a single list will produce multiple sheets (one to many - see image above). The problem arises when you have some sheets which have already been created and some new sheets which need to be created. As such we need to test for the existence of the sheet. In the following article I explore the VBA code required to test if a sheet exists without the use of a traditional custom function.
Read MoreFeatured Posts
Recent Posts
Populating an Excel Table from a Range of Cells with VBA June 12, 2025
Fuzzy Distribution with Randbetween May 21, 2025
Add Minimum and Maximum for Chart in Cells March 12, 2025
Inflation Over Multiple Years in a Single Cell January 10, 2025
Hubspot Dashboard October 3, 2024
Monthly Dashboard With Supporting Metrics September 25, 2024
Excel Show Missing Sheet Tabs July 29, 2024
Run Macro Overnight Automatically June 24, 2024
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023