|If you post a small sample of what your sheet looks like, we might be able to |
shorten the time even more.
Please use Column Letters and Row numbers, and read this HOW-TO which
explains the use of the < PRE > tags to align your data.
What I need to do now is to take each of those subtotals and copy just the state abbreviation and tax amount into a new location so that I have all 50 states listed in one column (only 50 rows not 100s) and the next column has the corresponding taxes.
Are the Subtotal cells identified in any way?
Do they have an adjacent cell that says something like "CT Subtotal"?
Are you using the DATE, associated with the item, in any way?