Run a macro after selecting an employee from Drop-down list

[MNThompson4]

Good Morning,

I am trying to create a Macro that will run when I select an employee from a Drop-down list.The drop-down list contains 21 employees and I need the macro to auto-fill their schedule into the first row of my spreadsheet when selected. Currently when I select an employees name it auto-fills 6 rows of the spreadsheet with Data using VLOOKUPS. I need to copy the formatting of the Schedule information, which is why I have not used a VLOOKUP for this data as well. I have been able to write a simple VB code for the first employee, but it remains stagnant when the next employee is selected. Can I assign a Range to each employee with several different codes since the row and columns will stay the same on my spreadsheet or do I need a separate Macro for each employee in the drop-down?

The code I am currently using is below:

Please Login or Register  to view this content.

[JBeaucaire]

We would have to see this workbook to guess at the code accurately. Your macro is going to have to:

1) ...be built into a Worksheet_Change even macro stored in the sheet module so it triggers itself
2) ...detect the change to the correct cell(s) before triggering
3) ...find the name selected in the other sheet before copying the needed cells and formatting.


Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[MNThompson4]

I have uploaded a scaled down version of my workbook due to confidential information. The critical pieces are still present. The Master tab contains the line I am trying to fill with the Macro (Row 5) and the Attendance tab is where the schedule is currently located. The drop-down is located in Row 2 on the Master tab.

Please let me know if you need any additional information.

Thanks!