markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Good evening
I have a report of few thousand lines that I'm trying to sort in a better way.
Column E has Customer last name from E7 e.g. Smith
Column K contains reference number date from K7 - the reference number is in the following format: TH_G0_S10_H_13084129
I'm looking for some macro code that will do the following
1. Add the customer last name to the reference number is column K so the reference number will look like this: Smith_TH_G0_S10
2. Remove the H_ number from the reference number column and add to column O so column O will read H_13084129
Any help you can give would be much appreciated.
Thanks in advance.
Mark
I have a report of few thousand lines that I'm trying to sort in a better way.
Column E has Customer last name from E7 e.g. Smith
Column K contains reference number date from K7 - the reference number is in the following format: TH_G0_S10_H_13084129
I'm looking for some macro code that will do the following
1. Add the customer last name to the reference number is column K so the reference number will look like this: Smith_TH_G0_S10
2. Remove the H_ number from the reference number column and add to column O so column O will read H_13084129
Any help you can give would be much appreciated.
Thanks in advance.
Mark