Sub Total - how to get customer name and other Text Columns

I have a report with three levels of Sub Total.
Level 3 is customer's aging for example the below 7 columns and the group total is by customer name. At the first level I get the customer name. I want to see Customer Number , rep and Region,
I am doing it by copying the first Total column and pasted in each and every Total Column, which takes lof of time, some times the reports can be thousands of lines.

A1 B1 C1 D1 E1 F1 G1
Customer Customer Name Rep Region Invoice Invoice Balance Past Due

Does any one have a function or a macro can do this? I searched on the net did not find anything would meet my needs?
Appreciate your help
I have also attached a sample file.
Thank you
Muthus

Yes. I do the sub total and get the total for columns G and H , but I also wants to see the text columns, Customer #, Customer Name, Rep and Region:
Customer Customer Name Rep Region Invoice Balance Past due
200060 Customer 1 MS NA 113,639.72 0.00
200065 Customer 2 KN SA 3,575.72 3,575.72
200069 Customer 3 DV other 2,300,024.79 2,308,540.71

Originally Posted by Muthus

I have a report with three levels of Sub Total.
Level 3 is customer's aging for example the below 7 columns and the group total is by customer name. At the first level I get the customer name. I want to see Customer Number , rep and Region,
I am doing it by copying the first Total column and pasted in each and every Total Column, which takes lof of time, some times the reports can be thousands of lines.

A1 B1 C1 D1 E1 F1 G1
Customer Customer Name Rep Region Invoice Invoice Balance Past Due

Does any one have a function or a macro can do this? I searched on the net did not find anything would meet my needs?
Appreciate your help
I have also attached a sample file.
Thank you
Muthus

Customer name may be duplicate. I think you should make subtotal according to customer no.

I have attached a file.
The sub total column originally was only with Customer number and Invoice balance and past due
Customer Customer Name Rep Region Invoice Invoice Date Invoice Balance Past due
200060 113,639.72 0.00
200065 3,575.72 3,575.72
200069 2,300,024.79 2,308,540.71

I copy customer name from a column above Customer name, Rep and Region. I am thinking a macro to repeat the copy and paste would help, but I just could not write a code, I am a novice in Macro.
I get my report like this:

Customer Customer Name Rep Region Invoice Invoice Date Invoice Balance Past due
200060 Customer 1 MS NA 113,639.72 0.00
200065 Customer 2 KS CA 3,575.72 3,575.72
200069 Customer 3 DV EA 2,300,024.79 2,308,540.71

Hi Kaper,
This is awesome. You are a excel Genius! It worked like a charm and it saves my time and improves my efficiency . I got to tell you, I cannot even imagine how did you put these steps together! It took me about 10 tries to succeed just following your steps.
Great!
Thank you