Excel Active list automatically populating from waiting list after deletion of an active user

%3CLINGO-SUB%20id%3D%22lingo-sub-2021533%22%20slang%3D%22en-US%22%3EExcel%20Active%20list%20automatically%20populating%20from%20waiting%20list%20after%20deletion%20of%20an%20active%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2021533%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20have%20around%20200%20lockable%20locker%20assigned%20to%20various%20members%2C%20and%20there%20is%20a%20waiting%20list.%20Once%20someone%20no%20longer%20needing%20a%20locker%2C%20next%20person%20from%20waiting%20list%20(oldest%20date)%20gets%20assigned%20that%20locker%20space%20and%20that%20entry%20from%20waiting%20list%20gets%20deleted%20Example%20GF002%20and%20GF005%20in%20attached%20file%20(%20see%20sheets%203%20%26amp%3B%204%20as%20they%20show%20end%20result)%20Can%20you%20help%20me%20with%20Automating%20this%20process%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F913384%22%20target%3D%22_blank%22%3E%40Bazza_1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2021533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Hi I have around 200 lockable locker assigned to various members, and there is a waiting list. Once someone no longer needing a locker, next person from waiting list (oldest date) gets assigned that locker space and that entry from waiting list gets deleted Example GF002 and GF005 in attached file ( see sheets 3 & 4 as they show end result) Can you help me with Automating this process ?

 

@Bazza_1 

0 Replies