Hi,
I am looking to create a Macro that will look at a list from sheet 'Data'
Case owner review
001 a Y
002 b Y
003 a Y
004 c Y
005 c N
006 b Y
007 a Y
Then duplicate sheet 'Template' the number of case numbers under an owners name marked for review, place the Case name in A1 of each sheet, name the sheet the Case number, and save the file as 'review - owner dd/mm/yy' and do this for each owner.
So File 'Review - a dd/mm/yy' would have 3 named sheets with case number in A1
b would have 2 and c would have 1
I am looking to create a Macro that will look at a list from sheet 'Data'
Case owner review
001 a Y
002 b Y
003 a Y
004 c Y
005 c N
006 b Y
007 a Y
Then duplicate sheet 'Template' the number of case numbers under an owners name marked for review, place the Case name in A1 of each sheet, name the sheet the Case number, and save the file as 'review - owner dd/mm/yy' and do this for each owner.
So File 'Review - a dd/mm/yy' would have 3 named sheets with case number in A1
b would have 2 and c would have 1