Great help from this Group always
Regards
Great help from this Group always
Regards
Last edited by prkhan56; 08-17-2017 at 02:47 AM. Reason: Solved
Hi prkhan56
FYI ...When running my code on your uploaded sample
Lrow gave a value of 294...I deleted rows 14-295 on Before sheet
nRow gave a value of 283... I deleted rows 2-284 on After Sheet
Try this....
Please Login or Register to view this content.
Last edited by sintek; 08-16-2017 at 09:48 AM. Reason: Changed code ----Added App.ScreenUpdating
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
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.
the uploaded samples have different scenarios...My code works for 2 or more Customers....
Herewith amended...Not sure what you mean by
I had given Cust1, Cust2 etc for explanation. Is it possible to get the actual values same as for the Description1, Description2 etc.
Edit...Please Login or Register to view this content.
Perhaps uploading a sample depicting your actual scenario might assist...
Last edited by sintek; 08-16-2017 at 01:46 PM.
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
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
My amended...Although jindon's solution is far more superior.
Please Login or Register to view this content.
Last edited by sintek; 08-17-2017 at 02:07 AM.
Thanks Sintek,
Great help.
Post Marked SOLVED
PS: Jindon thanks to you also
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks