Creating multiple tables in a single Date from Table operation in Excel

Copper Contributor

I have a large table containing data which I need to split.  I currently do this by using the Data From Table option, then filtering the data to create a new Table only containing the filtered data, I then find I have to use the File -> Close and Load option to save the newly created Table in a new tab in the workbook, then repeat the operation for the next set slice of data.  

Is there anyway for me to create multiple tables during a single Data -> From Table session using multiple filters then do a single File -> Close and Load to create all tables as new tabs in the workbook?

1 Reply