Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

Copper Contributor

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