<div>
This is ideal scenario for Advanced Filter function with option to copy to another location selected. Just AF wouldn't create the tabs for you but it could be used to populate them.<br />
<br />
Thanks<br />
Rob H
</div>


This is ideal scenario for Advanced Filter function with option to copy to another location selected. Just AF wouldn't create the tabs for you but it could be used to populate them.

Thanks
Rob H

<div>
Hi mvidas, <br />
<br />
This was perfect.... did exactly what i was trying to achieve!<br />
<br />
Thank you so much :)
</div>


Hi mvidas,

This was perfect.... did exactly what i was trying to achieve!

Thank you so much :)

<div>
<div class="content wysiwyg-content">
Hi EE, <br />
<br />
I need some help with a VB script/Macro to create/add worksheets based off the unique &nbsp;distinct values of a specific column in a master worksheet (Column C in Master). <br />
Then move/add the matching values to the corresponding worksheet.<br />
<br />
So with the example below there is only 3 distinct values (Cat A, Cat B, Cat C) in column C<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/11_w46/687414/Excel1.PNG" target="_blank" title="Master (19 KB)"><img alt="Master" class="file-block lazyload" style="max-width: 411px;" data-src="https://filedb.experts-exchange.com/incoming/2013/11_w46/687414/Excel1.PNG" /></a><br />
Using the values create the worksheets.<br />
<b>CAT A</b> and move all the corresponding value from master<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/11_w46/687415/Excel2.PNG" target="_blank" title="CAT A (9 KB)"><img alt="CAT A" class="file-block lazyload" style="max-width: 305px;" data-src="https://filedb.experts-exchange.com/incoming/2013/11_w46/687415/Excel2.PNG" /></a><b>CAT B</b> and move all the corresponding value from master<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/11_w46/687416/Excel3.PNG" target="_blank" title="CAT B (9 KB)"><img alt="CAT B" class="file-block lazyload" style="max-width: 315px;" data-src="https://filedb.experts-exchange.com/incoming/2013/11_w46/687416/Excel3.PNG" /></a><b>CAT C</b> and move all the corresponding value from master<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/11_w46/687417/Excel4.PNG" target="_blank" title="Cat C (9 KB)"><img alt="Cat C" class="file-block lazyload" style="max-width: 307px;" data-src="https://filedb.experts-exchange.com/incoming/2013/11_w46/687417/Excel4.PNG" /></a><br />
Thank You EE
</div>
</div>


Excel4.PNG

Excel1.PNG

Excel3.PNG

Excel2.PNG

Hi EE, 

I need some help with a VB script/Macro to create/add worksheets based off the unique  distinct values of a specific column in a master worksheet (Column C in Master). 
Then move/add the matching values to the corresponding worksheet.

So with the example below there is only 3 distinct values (Cat A, Cat B, Cat C) in column C


Using the values create the worksheets.
CAT A and move all the corresponding value from master

CAT B and move all the corresponding value from master

CAT C and move all the corresponding value from master


Thank You EE

Excel Worksheet from Unique Values in Column and move corresponding Data.

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.