Macro or VBA to sort values

ntldr123

New member
Joined
Apr 27, 2022
Messages
1
Reaction score
0
Points
0
Excel Version(s)
16
Hi


My spreadsheet has 100 values on column B from B6 to B106the values have the below form

AB, BC, CD, DE

I need to copy the column D the AB values, in column E the BC values, in column F the CD values, in column G the DE values


I tried to create a macro however, i didn't succeed. can anyone help?


Thanks!
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,170
Reaction score
12
Points
38
Excel Version(s)
365
cross posted without links:
https://www.msofficeforums.com/excel-programming/48922-macro-vba-sort-values.html
https://www.excelforum.com/excel-programming-vba-macros/1376924-macro-or-vba-to-sort-values.html
https://www.mrexcel.com/board/threads/macro-or-vba-to-sort-values.1203432/

Where there have been several responses, including from me at msofficeforums.
ntldr, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184
 
Top