|
Find & Retrieve a Set of Data
I consolidate data for many different regions... which should not be able to see each others' sales data...
I have a column that indicates the region and then the sales data by sales person.
I've created a drop down box (through data validation) to allow a user to select their territory, however what is the best way for me to get the data from my list to return once a territory is selected?
Other things to note, each territory has a different number of sales people, and certain territories have subtotals for states, which is the way I'd like the data to be shown to the user.
I've created password restrictions with VBA to prevent users to only see the territories they have access to in the dropdown box.
What I need, specifically, is FIND the territory that is selected, and then copy all of that info (with varying numbers of lines, but all with that territory at the start) and return it in the exact format as I have in my list.
Is this possible?
Last edited by kwgriffi; 06-26-2009 at 05:39 PM.
|