Peta Durose
New Member
- Joined
- Sep 27, 2022
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
I have two spreadsheets I need to streamline.
First is a list of 250 "clients" and the second is a list of 13 "case managers", each have a different level of capacity.
ie.
Case manager 1 has capacity of 5
Case Manager 2 has capacity of 3
I need to be able to auto populate so my "case managers" are auto assigned to the "clients".
Really hoping someone can help me fast!!
First is a list of 250 "clients" and the second is a list of 13 "case managers", each have a different level of capacity.
ie.
Case manager 1 has capacity of 5
Case Manager 2 has capacity of 3
I need to be able to auto populate so my "case managers" are auto assigned to the "clients".
Really hoping someone can help me fast!!