I am trying to automate a spreadsheet. I've written code in VB to run an autofilter and copy and paste selected data into a new worksheet. I now need to insert subtotals in the new sheet where a name in a column changes.
So for example I have 5 rows of data where the source name = A. On the 6th row the source name = B. Inbetween these two rows I need to insert a subtotal to sum the data for source name A, and then continue down for source B, C, D etc...
Is this possible to do?
I will be so greatful for any help on this
So for example I have 5 rows of data where the source name = A. On the 6th row the source name = B. Inbetween these two rows I need to insert a subtotal to sum the data for source name A, and then continue down for source B, C, D etc...
Is this possible to do?
I will be so greatful for any help on this