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.

Tags Excel, VBA, Master, Parent to Child, Create sheets