P
PVANS
Good morning
Currently, each day I am required to sort and "clean" an Excel Worksheet.
In this worksheet, there is a list of accounts. However, in this unordered
list, are pairs of each account with three extra characters on the end. eg:
100001/1000001
100001/1000002
100001/1000004
100002/2000002
100001/1000001DMA
100002/2000002DMA
I would like to create a macro that checks the first 14 characters from the
left of the values in Column A, and groups each pair together as well as
leaving a line between each set.
Please could someone provide me with some advice for this issue? I really
would appreciate it.
Regards,
Currently, each day I am required to sort and "clean" an Excel Worksheet.
In this worksheet, there is a list of accounts. However, in this unordered
list, are pairs of each account with three extra characters on the end. eg:
100001/1000001
100001/1000002
100001/1000004
100002/2000002
100001/1000001DMA
100002/2000002DMA
I would like to create a macro that checks the first 14 characters from the
left of the values in Column A, and groups each pair together as well as
leaving a line between each set.
Please could someone provide me with some advice for this issue? I really
would appreciate it.
Regards,