Subtotal Question

[Guest]

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?

 

[Frank Kabel]

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

 

[Guest]

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