Hello everyone,
I would like to grouping A column values according to *_1.jpg *_2.jpg *_3.jpg *_4.jpg *_5.jpg column by cloumn as in the pic.
Could anyone help me how to make this with a macro ?
Thank you all.
Asdfsdfdsız.png
Hello everyone,
I would like to grouping A column values according to *_1.jpg *_2.jpg *_3.jpg *_4.jpg *_5.jpg column by cloumn as in the pic.
Could anyone help me how to make this with a macro ?
Thank you all.
Asdfsdfdsız.png
Using your posted sample, try the following code:
Will there ever be an instance where the second number will not reset to 1?Please Login or Register to view this content.
1_1.jpg
2_2.jpg
3_2.jpg
4_3.jpg
5_4'jpg
Maud
Thank you for your quick reply Maud
No, There will always be _1.jpg suffix starting in order. Working great. Once again appreciated your help.
Actually, It gives "Subscript out of range" error when there are 50 values in A column. How to make that range about 30K ?
Breeze,
I recreated the workbook with 100 lines, ran the code, and found no errors. I suspect you may have inadvertently added a value that did not have a "_" or a "." characters. I revised the code to have error checking and to notify you where the error is located. It should handle as many lines as your version of Excel could support as well as columns for the sequential second number
HTH,Please Login or Register to view this content.
Maud
Last edited by Maudibe; 02-12-2017 at 01:40 PM. Reason: added file
It's working perfectly Maud Your a star, thank you so much
Thanks for the rep points!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks