Cut entire rows of worksheet where column 'vEmailAddress' contains duplicate. New Worksheet for each set

[Benison69]

Hi, I have a workbook with Columns in A:AB. This is an extracted CSV file so column positioning may change.
I'm looking for a VBA script, to sort column vEmailAddress, for any duplicates to cut entire row to a new worksheet/ workbook. Each worksheet/book, must be a unique list, without loosing any of the data.

Example:
Source Table:

fName	lName	vEmailAddress	Cost
fred	bloggs	jbloggs@gmail.com	£34
tim	smith	smith@gmail.com	£12
joe	bloggs	jbloggs@gmail.com	£20
james	smith	smith@gmail.com	£10
Becky	Bloggs	jbloggs@gmail.com	£18
tom	tom	tom@gmail.com	£20

Desired Output:
Workbook1

fName	lName	vEmailAddress	Cost
fredd	bloggs	jbloggs@gmail.com	£34
tim	smith	smith@gmail.com	£12
tom	tom	tom@gmail.com	£20

Workbook2

fName	lName	vEmailAddress	Cost
joe	bloggs	jbloggs@gmail.com	£20
james	smith	smith@gmail.com	£10

Workbook3

fName	lName	vEmailAddress	Cost
Becky	Bloggs	jbloggs@gmail.com	£18

Hope this makes sense! I have tried lots of vba examples I've seen already but none working quite as I need!

Thanks,
Matt

 

[Benison69]

Is anyone able to assist?

Thanks,
Matt

 

[Benison69]

Hi, I have a workbook with Columns in A:AB. This is an extracted CSV file so column positioning may change.
I'm looking for a VBA script, to sort column vEmailAddress, for any duplicates to cut entire row to a new worksheet/ workbook. Each worksheet/book, must be a unique list, without loosing any of the data.

Example:
Source Table:

fName	lName	vEmailAddress	Cost
fred	bloggs	jbloggs@gmail.com	£34
tim	smith	smith@gmail.com	£12
joe	bloggs	jbloggs@gmail.com	£20
james	smith	smith@gmail.com	£10
Becky	Bloggs	jbloggs@gmail.com	£18
tom	tom	tom@gmail.com	£20

Desired Output:
Workbook1

fName	lName	vEmailAddress	Cost
fredd	bloggs	jbloggs@gmail.com	£34
tim	smith	smith@gmail.com	£12
tom	tom	tom@gmail.com	£20

Workbook2

fName	lName	vEmailAddress	Cost
joe	bloggs	jbloggs@gmail.com	£20
james	smith	smith@gmail.com	£10

Workbook3

fName	lName	vEmailAddress	Cost
Becky	Bloggs	jbloggs@gmail.com	£18

Hope this makes sense! I have tried lots of vba examples I've seen already but none working quite as I need!

Thanks,
Matt

Does anyone have any suggestions for this macro?