VBA / Top 70% based on previous months production

[LisaCervantes]

Hello...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am trying to create a spreadsheet (Calculator Tab) that will allow management to assign employees to an assignment based on there production totals from the previous month. Here is a little background:<o></o>
<o></o>
-There are three different assignments - EUC, eApply and EDDCOMM<o></o>
-Each assignment has a tab to record production total for the month.<o></o>
-Daily management is given a certain number of employees that they need to assign to a certain assignment.<o></o>
-Management wants to assign 70% of employees to an assignment based on production totals.<o></o>
-There is a summary page with the following macros SortByEapply , SortByEDDCOM , SortByEUC which allow the spreadsheet to be sorted in top producers for each task. <o></o>
<o></o>
So far on my calculator page I have:<o></o>
<o></o>
- created a drop down box to select an assignment (cell B1)<o></o>
- creates a dropdown box to select # of employees assigned to task (cell B2)<o></o>
- Cell IU1 (hidden) calculates 70% of the number of employees assigned<o></o>
<o></o>
Based on the info selected on the calculator page I would like a macro in place to populate a list of employees assigned to an assignment (I am assuming the data will be retrived from the summary sheet.<o></o>
<o> </o>
Example of what I want:<o></o>
<o> </o>
If B1 is set to EUC and B2 is set to 50 (UI1 will appear as 35, 70% of 50), I want the macro to go to the summary page, sort by EUC, copy the top 35 names (B3:B37 [names will always start with cell B3 through how ever many cells should be selected]) and post them on my calculator page starting on cell A5.<o></o>
<o> </o>
Thank you to anyone out there who can help me, I dont know where to start!!!<o></o>
<o> </o>