Macro or VBA to sort values

[SIPRIAN]

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!

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Macro or VBA to sort values
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Joe4]

I find your question a little confusing. I think it would be much clearer if you could show us an example of your data and expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[SIPRIAN]

I find your question a little confusing. I think it would be much clearer if you could show us an example of your data and expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Please see file attached.

Easyupload.io - Upload Files and Share Them Easily

Uplaod files easily and share them with your friends and colleagues. File upload solution for everyone. Upload big files and get a link to share effortlesly.

easyupload.io

 

[Joe4]

I cannot download files from my current location, but seeing as how it looks like you already have people helping you in your other thread, I will leave it to them.

 

[Macropod]

Also cross-posted at:

Macro or VBA to sort values

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...

www.excelguru.ca

Macro or VBA to sort values

[Solved] Macro or VBA to sort values Excel Programming

www.msofficeforums.com