When I use the subtotals function in Excel, I have the subtotal added to the
row below each change in criteria. My problem is that I only need the
subtotals and when I hide the other rows I lose some information - such as a
property identifier in column A.

I was wondering if anyone had ever written a macro that would evaluate each
cell in column A and if it was blank, have the macro copy the contents of the
cell directly above it. For example, if Cell A13 is blank (because Excel
used row 13 to subtotal some lines above it), have the Macro copy the
contents of Cell A12 into Cell A13. If a cell in column A already has data,
I want to leave the cell as is.

I would need this to cycle through all the rows in the spreadsheet - the
number of rows changes each month.

Thanks,

Tim

If all you are looking for is the subtotal why not use a pivot table. In a
pivot table you can show only the aggregates without any of the details. All
of the appropriate hedings are shown and IMO they look better in the end.
--
HTH...

Jim Thomlinson


"TJN" wrote:

When I use the subtotals function in Excel, I have the subtotal added to the
row below each change in criteria. My problem is that I only need the
subtotals and when I hide the other rows I lose some information - such as a
property identifier in column A.

I was wondering if anyone had ever written a macro that would evaluate each
cell in column A and if it was blank, have the macro copy the contents of the
cell directly above it. For example, if Cell A13 is blank (because Excel
used row 13 to subtotal some lines above it), have the Macro copy the
contents of Cell A12 into Cell A13. If a cell in column A already has data,
I want to leave the cell as is.

I would need this to cycle through all the rows in the spreadsheet - the
number of rows changes each month.

Thanks,

Tim