I have a large database of professionals and want to select a certain type under the position column. Such as, 'Financial Advisor'. And then, transfer all of the Financial Advisors to another workbook.
If that's one-time operation you may filter the data and copy/paste into another workbook. Power Query could be an option if data is changing from time to time.
