Hello,
I'm not sure if this should do with either formula or macro. I have a drop down list of manager and in the data spreadsheet Column A contain names of the manager and column B contains stores that managers are in charge. I need to be able to use drop down list to select the manager and then below it will automatically populate any stores that the manager is in charge.
Thanks
Bookmarks