Hi All,
I would like to filter a sheet and paste those records onto a new sheet in the same workbook. I would like to email each sheet to the field selected for that filter.
I am using the Supervisor's name in order to create that filter. Each has from 5 to 10 employees. I want each supervisor to get their own sheet with their subordinates information on it. I want to email that information using Outlook. currently using Excel 2013.
I would like this process to be done automatically using VBA.
The following is part of that code in Excel Macro VBA used to copy paste but it does it for one selection. I want it to be continuous for all listed supervisors in that same column.
I would like to filter a sheet and paste those records onto a new sheet in the same workbook. I would like to email each sheet to the field selected for that filter.
I am using the Supervisor's name in order to create that filter. Each has from 5 to 10 employees. I want each supervisor to get their own sheet with their subordinates information on it. I want to email that information using Outlook. currently using Excel 2013.
I would like this process to be done automatically using VBA.
The following is part of that code in Excel Macro VBA used to copy paste but it does it for one selection. I want it to be continuous for all listed supervisors in that same column.
Code:
Rows("1:1").Select
Selection.AutoFilter
Range("G2").Select
ActiveSheet.Range("$A$1:$U$57").AutoFilter Field:=7, Criteria1:= _
"Jones, Mat "
Range("A1:U30").Select
Selection.Copy
Sheets("Sheet1").Select
Rows("1:1").Select
ActiveSheet.Paste
Sheets("Merit Increase Return").Select
Application.CutCopyMode = False
