Hello all!
I am looking for a way to summarize numerous rows of data. It could possibly exceed 100k rows. For example, column A is a reference #. I need to count how many times this row is listed. Column H is an amount and I need for it to subtotal each reference #. For example Row A is 1234 and there are 100 instance that total $50000. I need this to happen at each change in column A and, if possible, copy the data to a new spreadsheet.
Would this be possible with VBA?
Thanks in advance!!
I am looking for a way to summarize numerous rows of data. It could possibly exceed 100k rows. For example, column A is a reference #. I need to count how many times this row is listed. Column H is an amount and I need for it to subtotal each reference #. For example Row A is 1234 and there are 100 instance that total $50000. I need this to happen at each change in column A and, if possible, copy the data to a new spreadsheet.
Would this be possible with VBA?
Thanks in advance!!