jo15765
11-20-2012, 06:49 AM
In Excel I am importing a SQL Stored Procedure to sheet one and using vba to filter:
Selection.AutoFilter Field:=2, Criteria1:="EmployeeNames"
Selection.AutoFilter Field:=5, Criteria1:="StillActive"
Sheets.Add.Name = "Still Active Employee"
Now the predicament I have is that need to copy Column A from the SQL Stored procedure (Sheet1) to Column B starting in Row 4 going down, then copy (again Sheet1) Column D to Column G to Still Active Employee sheet. And also, any records from Sheet1 that are flagged as 'Yes' in Column C need to be highlighted in Yellow on Still Active.
I have been scratching my head for 3 days now trying to tackle this!! Guidance please?!
Selection.AutoFilter Field:=2, Criteria1:="EmployeeNames"
Selection.AutoFilter Field:=5, Criteria1:="StillActive"
Sheets.Add.Name = "Still Active Employee"
Now the predicament I have is that need to copy Column A from the SQL Stored procedure (Sheet1) to Column B starting in Row 4 going down, then copy (again Sheet1) Column D to Column G to Still Active Employee sheet. And also, any records from Sheet1 that are flagged as 'Yes' in Column C need to be highlighted in Yellow on Still Active.
I have been scratching my head for 3 days now trying to tackle this!! Guidance please?!