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?
