<div>
<div class="content wysiwyg-content">
Hi - I would like to replicate worksheet titled &quot;Master&quot; in an Excel workbook to various tabs, each tab should receive a name which will be listed in Column A of worksheet titled &quot;List&quot;. &nbsp;For example, cell A1 = &quot;apples&quot;, cell A2 = &quot;oranges&quot;, cell A3 = &quot;pears&quot;, etc... The code should look at column A and automatically know how many worksheets to create based on the list of names. &nbsp;There will be no spaces between each cell. &nbsp;Thansk in advance!
</div>
</div>


Hi - I would like to replicate worksheet titled "Master" in an Excel workbook to various tabs, each tab should receive a name which will be listed in Column A of worksheet titled "List".  For example, cell A1 = "apples", cell A2 = "oranges", cell A3 = "pears", etc... The code should look at column A and automatically know how many worksheets to create based on the list of names.  There will be no spaces between each cell.  Thansk in advance!

Replicate master worksheet with different names

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.