VBA to split single worksheet into multiple files & summarize data with pivot table
I have one worksheet with hundreds of unique elements in column B that need to be separated by those elements into separate files (this part I've been able to achieve with extensive searching)... But I also want to be able to summarize each of the new files via a pivot table, or the like. I don't necessarily need the drill down capability of a pivot table, but do want to be able to show totals for 4 different values from column G. Any insight?
I have one worksheet with hundreds of unique elements in column B that need to be separated by those elements into separate files (this part I've been able to achieve with extensive searching)... But I also want to be able to summarize each of the new files via a pivot table, or the like. I don't necessarily need the drill down capability of a pivot table, but do want to be able to show totals for 4 different values from column G. Any insight?