Hi,
I have a roster in A sheet and in B sheet I have the positions I need to run my company.
Every name in A sheet will be in B but not in the same order, I want some help so that if someone left the company I will delete his name in the roster A sheet and I want the same name to be deleted in B sheet. I want only name to be deleted not the position he is assigned to.
A sheet B Sheet
Name Hire date Name Position
John 10/17/2016 Sam Sales Manager
Paul 10/18/2016 Paul Inventory Manager
Sam 10/16/2016 John Clerk
So if I delete the John row in A sheet, I want to able to delete John in B sheet but leave the position on it.
Bookmarks