Need Code to Split a Excel Master sheet into multiple work sheets based on values in on Column.

[sridhar0v]

Hi,

My Excel sheet has many Testcases and each test case has multiple scripts in it as shown below

ColumnE ColumnG ColumnO
TestCase1 TestScript1 Step1
Step2

TestScript2 Step1
Step2

TestCase2 TestScript1 Step1
Step2

TestScript2 Step1
Step2


I want to have only TestCase1(the rows in red) in one workbook and TestCase2(the rows in green) in another workbook and so on. i.e One new workbook created for each Testcase with that name and the rows copied to it.


Please can any one provide me the script for this.

Thanks