I have a raw data file of sales opportunities and would like to automatically identify and copy the TOP 10 Optys onto a new Wkst. Further, I would like this to become a template wherein I can add opportunities to the raw data worksheet overtime and still have those TOP 10 Optys continue to be auto identified and copied onto the designated new Wkst (so only 10 total optys remain).
Do you have any Access experience? If not then you are at the same knowledge level as with the excel program, except Access is for maintaining records in a scaleable solution! Where excel is for calaculating complex math problems. Let us know if you need help with table structures.
If you insist on using excel, then I encourage you to record a macro of what you want to happen, then edit it with values that are variables. If you need help with that, post your maceo jere for review.