Hi all,
First of all, thank you for all that you do. Searching these forums and Google is a task at times, but so worth it creating new and improved files.
Ok, so here it goes. I work in insurance and have a file of preferences and contact information split out by region (e.g. Chicago, Boston, New York City, etc.). Each region is on a separate tab with the Sales Reps' contact info as attached (confidential information removed for this thread). Each cell with the Sales Reps per Sales office is a single cell with multiple lines. So, each cell has carriage returns for each additional Rep. This is the same for the Rep name, Rep email, and Rep number.
At this time, each contact info is updated individually. I'd like to change this and do so on the master Rep sheet. Issue: Once I do this, I'm looking to run a VBA filter command to filter information based on the master Rep sheet and return the names, email, and #s of Reps in a region/office back into the individual regional cell as a multiline cell. The aim is to have this be dynamic enough where you would only have to change the master sheet and the VBA would update from there (if a button is needed, no worries there).
I'm hoping this is enough info for anyone who is willing to help. Somewhat difficult to reinvent this document while removing all the confidential data. If you have any questions or need more info for insight, please let me know. Your help is greatly appreciated!
Bookmarks