Good afternoon all,
I have a task at hand where I have a large data set (let's call it 50k lines by 15 columns to make it easy). I need to separate that data set into new worksheets/files (either, or) based on the value of one of the columns in that data set. The easiest way I've been able to do it is by making a pivot table, filtering a value, and then double clicking the "Grand Total" at the bottom. Then I change the filter and repeat. There are about 50 different values in that one column, so I end up doing this ~50 times. Is there a macro or something that can do this automatically?
I have seen a few macro codes out there, but they're not giving me all the different values and only doing one at a time when I run them.
I have a task at hand where I have a large data set (let's call it 50k lines by 15 columns to make it easy). I need to separate that data set into new worksheets/files (either, or) based on the value of one of the columns in that data set. The easiest way I've been able to do it is by making a pivot table, filtering a value, and then double clicking the "Grand Total" at the bottom. Then I change the filter and repeat. There are about 50 different values in that one column, so I end up doing this ~50 times. Is there a macro or something that can do this automatically?
I have seen a few macro codes out there, but they're not giving me all the different values and only doing one at a time when I run them.
