Subtotal Question
 

I subtotal on column A. Need the infomration in column B and column C to be
copied to the subtotal line for column A. Example:
Column A=Customer ID
Column B=Customer Name
Column C=Customer City, State etc
My sustotals on the customer ID, but would like to include the customer name
and customer city, state etc on the sub total line.
Can this be done systematically?
--
Bill McMichael

Hi
not with Excel's built-in features. Would VBA be feasible for you?

--
Regards
Frank Kabel
Frankfurt, Germany
"Bill McMichael" schrieb im
Newsbeitrag ...
I subtotal on column A. Need the infomration in column B and column C to
be
copied to the subtotal line for column A. Example:
Column A=Customer ID
Column B=Customer Name
Column C=Customer City, State etc
My sustotals on the customer ID, but would like to include the customer
name
and customer city, state etc on the sub total line.
Can this be done systematically?
--
Bill McMichael

Hi Frank,
Possibly, I'm not very familiar with VBA

"Frank Kabel" wrote:

Hi
not with Excel's built-in features. Would VBA be feasible for you?

--
Regards
Frank Kabel
Frankfurt, Germany
"Bill McMichael" schrieb im
Newsbeitrag ...
I subtotal on column A. Need the infomration in column B and column C to
be
copied to the subtotal line for column A. Example:
Column A=Customer ID
Column B=Customer Name
Column C=Customer City, State etc
My sustotals on the customer ID, but would like to include the customer
name
and customer city, state etc on the sub total line.
Can this be done systematically?
--
Bill McMichael