This macro takes thousands of lines of data and splits it into separate spreadsheets based upon content in Column A. It then subtotals everything based upon changes in Column D, but subtotals in Column H.
I was wondering if this would all be possible, but to also keep the subtotaled columns minimized so that I just see the subtotal, and to additionally see what is listed for Columns A, C, D, and E? (I don't need these to be a calculation, just to essentially show the row(s) above it starting one row under the prior subtotal).
Basically those columns just give details about that row that I can't see unless the subtotal is expanded.
I have thousands of lines that I need to be minimized to totals and when they are minimized I can only see the "SubTotal" line with the dollar amounts listed there (Which is Column H).
I hope this isn't confusing, and thank you in advance for any assistance with this!
Please Login or Register to view this content.
Bookmarks