Thread
:
Column Subtotal Question
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Column Subtotal Question
I need the subtotals to be 2 rows below the last row with a value in
column D. I am stumped!
You would need to have the value set by a macro
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"brentm" wrote in message
...
I have a spreadsheet that I need to add a column subtotal for column C and
column D. the number of rows will vary from one run to the next. the
other
issue I have is that all rows with a value in column D are listed (by
sort)
below all rows with a value in column C. I can add subtotals, but I do
not
know how to set the range to be dynamic. Also, I need the subtotals to be
2
rows below the last row with a value in column D. I am stumped!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett