Menu
Excel 2007: Click the Office button, choose Excel Options, and then then enable the Show Sheet Tabs setting in the Display Options section of the Advanced options. Excel 2003 and earlier: Choose Tools, Options, Display, and then Show Sheet Tabs. Excel 2011 for Mac: Choose Excel, Preferences, View, and then Show Sheet Tabs.
I am not sure whether this is the right forum for using Power Query with Excel. I have connected to an excel file containing many rows of payroll data.
I am looking for a way to split the data into mutiple worksheets base on the values of a selected department column. In this way I can separately email the payroll data to each department. I can, of course, for each department create a reference from this source and filter the required department. But this solution only creates a fix number of worksheets, i.e., I need to know the number of departments before hand, create the reference and filter them in my Power Query. I need a solution to dynamically create new worksheet when a new department is found.