Macro to combine Qty and Price Columns separated by Total Columns

Hello Sintek,
Marvelous code!!

Some small tweaks if you could do it for me please it would really appreciated

1) ID shown in the sample is running numbers for sample only. Actual data it is an Alpha Numeric values. Is it possible to get the right 10 characters of the ID. Similar to =Right(a4,10)

2) I had given Cust1, Cust2 etc for explanation. Is it possible to get the actual values same as for the Description1, Description2 etc..

3) As mentioned in my original post, the macro should create the new sheet After and then paste the date in that sheet

Hope to get your valuable support

Thanks

Hello Sintek,
I thing I missed in the previous post.

You have posted test1 and test2...I think both are same.
Or are they different?

Thanks once again.

Please Login or Register  to view this content.

Dear Sintek
Thanks once again
Please see the comments in color

1) ID shown in the sample is running numbers for sample only. Actual data it is an Alpha Numeric values. Is it possible to get the right 10 characters of the ID. Similar to =Right(a4,10)
I want the right 10 characters of the ID

2) I had given Cust1, Cust2 etc for explanation. Is it possible to get the actual values same as for the Description1, Description2 etc..

Yes you are right my mistake in explaining. But you had used Cust* as the criteria. I think the Columns from C3 to the count of first Total in Row3 and then from the next column on the right side of the Total should be the criteria

My Cust Names are Alpha Numeric values
eg:
Cust1 Cust2 Cust3 Cust4 Cust5 Cust6 Cust7
12345 DFC 23456 AL WM 345 F C R B 1180 D M AE 667 MCC 111 YM AE 999 M CAE


3) As mentioned in my original post, the macro should create the new sheet After and then paste the date in that sheet - Thanks this is perfect now

Thanks once again for your prompt response to my problem

Hello Jindon,
Thanks for your code
Your code works for the sample I have provided but the OP says that the Cust will increase from 1 to N

The criteria is Total shown in Row 3 is Important

To the left of the first Total is the Qty and to the right of Total is Price

Your code works for 6 Columns i.e. 2 Cust + Total and 2 Cust + Price

Regards

Hello Sintek
While uploading the Cust Nos messed up
So I am attaching an excel file for clear understanding of the Customer Names

Regards

Originally Posted by prkhan56

Hello Jindon,
Thanks for your code
Your code works for the sample I have provided but the OP says that the Cust will increase from 1 to N

Where did you?

Please Login or Register  to view this content.

Hello Jindon,
Sorry, it was mentioned on the sample data 'Before' Sheet not in OP
Sorry once again.

Hope you now understand my requirement

Thanks

Thanks Sintek,
Great help.
Post Marked SOLVED

PS: Jindon thanks to you also