Home » Forums » Open Source Learning Center » Question and Answer

Userform for this code needed

Submitted by JJFletcher on 3 October, 2015 - 17:32

Hello,

I have the code working successfully, yet I am needing to have a Userform that populates the correct Agents data.

[code]=INDEX(OFFSET(EmployeeData!$AB$27,MATCH($M$4,EmployeeData!$AB$27:$AB$500,0),0,12,2),MATCH($AI$2,$W$4:$AH$4,0),2)[/code]

The Code above gets the data from the EmployeeData sheet and shows it in the ReviewAgents sheet. Need the Userform to populate the data in the Agents section by month in the employeedata sheet.

Here is a sample file, Any help or suggestions is appreciated.

Best Regards,

John

AttachmentSize
Sample3.xlsm59.78 KB
‹ Sorting and format issue Help Me Please!!! ›
»

Userform for this code needed

Submitted by Cheetahke on 6 October, 2015 - 15:09.

I will try to help with the userform, but first I have some questions.

  1. Do you need a listbox from where you choose the Agent, or do you choose the agent in the ReviewAgents sheet?
  2. Do you need a listbox from where you choose the month, or do you choose the month in the ReviewAgents sheet?
  3. How many textboxes are needed for the data that need to be populated?
»