Hello people of excel!
I am brand new to the forum. Brand new to VBA and moderate in Excel in general. Here's my problem:
I have thousands of rows of data for account transactions. Once the rows are sorted by account #, I need to separate each account with a blank space. Also I need to subtotal each account, BUT I need my subtotal to be located in the adjacent right column of the last value for each account. For example:
Account Description Amount Account Total
0001 Screws $1000 $1000
0002 Hammers $1000
0002 Hammers $1000 $2000
0003 Bolts $1000
0003 Bolts $1000
0003 Bolts $1000 $3000
I appreciate any help you can give.
Bookmarks