I would like my subtotal row to also include the other matchig data. Right now to get the results I want on my spreadsheet this is my process(I know there has to be an easier way):
subtotal at any change in column b add total to column f
then I copy and paste special values and number format to another spreadsheet
go to new sheet insert cell into column a,c,d,ande so that the other data will be in the same row as the subtotal
finally I delete all data without total in column b.
and delete the first sheet I did subtotals on.
I am writing a macro and would like an easier way to do this task.
Because I know I am terrible at explaining things I have attached worksheet. Sheet 1 is starting data sheet 2 is what I want after subtotal.example.xlsx
Any help would be greatly appreciated!
Bookmarks