Dazed and Confused!

[gitsie]

I am trying to find a way of using excel to automatically select a number of items from a list, based on how many are required.

So, for example - if in sheet 1 A3=4, 4 names/items must be pulled from a list that is on sheet 2 and appear in A5 on sheet 1. (but not as a dropdown list)

Is this possible? I'm beyond confused!

 

[Shteven]

Could you upload a workbook showing how your data is laid out and how you want to see your result?

 

[gitsie]

The workbook attached has all of the information.

Essentially, I need a way to automatically generate a selection of names from sheet 2 based on a figure that is on sheet 1. Then I need to ensure that the names selected can not be selected again elsewhere.

I know it's a lot of questions, I apologise.

 

[Im_Offset]

The workbook attached has all of the information.

Essentially, I need a way to automatically generate a selection of names from sheet 2 based on a figure that is on sheet 1. Then I need to ensure that the names selected can not be selected again elsewhere.

I know it's a lot of questions, I apologise.

So, you are trying to assign names (agents) to each line on the "res" tab? And the list of possible names is on the "Staff Pool" tab?

Does it matter who is assigned to each "task" on the Res tab? I understand that each name is to be used only once, however in your example you did not start with names at the top of the list.

 

[gitsie]

It doesn't matter who is assigned from each 'team', however the agents highlighted in green on the staff pool tab can only complete tasks that are Faults in Service - CSC Pools on the res tab. The agents that are highlighted in red can perform any task.