Hello,
I am looking for VBA code to look at my active worksheet, which has been subtotaled, and create a new worksheet within the same workbook for each group of subtotals, and ideally name each new sheet the name of the subtotal name.
For example, attached is my subtotaled information. I would like a new worksheet for ABC, DEF and GHI, named those, and then pull in row 1 (headers) for each, and then all the corresponding data that goes with each vendor. The number of different subtotals will vary but right now there can be as many as 20 with about 7000 lines of data.
Bookmarks