Require your assistance in Seating Allotment

Hi,

I work in a call center and would require your assistance on urgent basis in automating this file.

Details / Info:-

• In Sheet 2 tab of the attached excel file under F column I have the count of associates who are aligned to the respective team leaders,
• In Sheet 1 tab of the attached excel file under D column I have the seat numbers,
• The count of the associates under each team leaders is also not constant & keeps changing (increasing / decreasing)

Description of the issue

• When the total sum of associates increase the count of 250 I need to get a message box stating the actual count of associates are beyond the capacity of 250 hence reduce the count below / equal to 250.

• Assuming the count the is less than 250; the team leaders name needs to reflect the numbers of time which is mentioned in sheet 2 tab under f column.

• Each day the system numbers which is been dedicated to the each team needs to be changed for the following day,

• The associate cannot be shattered around the entire floor & need to sit in a group.

Thanks in advance for all the help,
Hi,

I work in a call center and would require your assistance on urgent basis in automating this file.

Details / Info:-

• In Sheet 2 tab of the attached excel file under F column I have the count of associates who are aligned to the respective team leaders,
• In Sheet 1 tab of the attached excel file under D column I have the seat numbers,
• The count of the associates under each team leaders is also not constant & keeps changing (increasing / decreasing)

Description of the issue

• When the total sum of associates increase the count of 250 I need to get a message box stating the actual count of associates are beyond the capacity of 250 hence reduce the count below / equal to 250.

• Assuming the count the is less than 250; the team leaders name needs to reflect the numbers of time which is mentioned in sheet 2 tab under f column.

• Each day the system numbers which is been dedicated to the each team needs to be changed for the following day,

• The associate cannot be shattered around the entire floor & need to sit in a group.

Thanks in advance for all the help,