OK i have looked all over and can't seem to find anyone who has had the same issue as i am.
I would like to create a VBA script that will Search Colum A for 4 employee names out of the list of about 20:
Julianne
Ramero
Allie
Louis
This list is dynamic so the row they are in is always changing.
Then select the corresponding row and cut and paste it to say A36:A40. The original row would also need to be deleted while maintaining the gap between employees.
I have attached a copy of it with sheets labeled before and after to show what result i am hoping to get! Thanks in advance! Gary