Here's what I'm needing:
In column "S" of my worksheet I need:
- look for "lock", "AD", "Group"
- Move the row to another sheet named "Active_Directory"
- Delete the Blank line where I just moved the data from
- Count how many times this is done and store write the number to a different sheet called "Totals" as in the example below
Begininning in cell A5:
Active Directory 37
Where 37 is the number of times it was found in the "S" column and moved to the "Active_Directory" sheet.
Any help would be appreciated.
Thank you.
Bookmarks