Help Autopopulate

Peta Durose

New Member
Joined
Sep 27, 2022
Messages
12
Office Version
  1. 365
Platform
  1. 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!!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Upload sample data using XL2BB to understand the scenario and help you in best possible way.
1665005137549.png
Sheet 1 = Clients details
1665005184861.png
sheet 2 = referral tool (auto populates from Sheet 1)
1665005263238.png
Sheet 3 = Cm's / Cp's and their capacity.

I need the information from sheet 3 to go into sheet 2 - where it randomly populates in the "referred to" cell.
But the populating cannot exceed the Capacity.
 
Upvote 0
I have been trying hard for last 4 hrs to find a solution using formulae but whichever method I use, it gives circular reference error.

Probably someone expert at VBA may visit the post and help you out.
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,254
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top