senior thesis needs help with a data sort

[sjc4]

hi all,

first of all thanks for reading over this. to give you some background i am working on my senior thesis and i need to sort through a bunch of data. i am trying to sort this data using VBA because i think it will be much more effecient and will have a longer use.

here is the problem/picture (i have about 300 sheets that i need to sort like this):

I need to align the ABCD return table on the left with the other return table on the right so that i can compare the two table's percentages. essentially, i am trying to align these tables next to each other so that they are ascending downward and i can compare and contrast the dates and percentages. thanks for your help any tips, answers and additional questions welcome.

 

[sjc4]

@levifunk

sorry for questioning so much, but can you speculate as to why markmzz's formulas are not working for me and only returning "VALUE!" ? im so close to getting this process automated... i will never surrender!

 

[levifunk]

@levifunk

sorry for questioning so much, but can you speculate as to why markmzz's formulas are not working for me and only returning "VALUE!" ? im so close to getting this process automated... i will never surrender!

Its because you didn't import Column A as a date. If you can't figure out how to do that, try this formula instead: ="CY"&LEFT(A2,4)&"Mon"&LEFT(RIGHT(A2,5),2)

 

[sjc4]

thanks a lot. im going to try out your formula. ill also try to import column A as a date to satisfy my own curosity.

thanks again!

Its because you didn't import Column A as a date. If you can't figure out how to do that, try this formula instead: ="CY"&LEFT(A2,4)&"Mon"&LEFT(RIGHT(A2,5),2)

 

[markmzz]

can you email that sheet to me? i'll pm you my email if that is okay.

Sjc4,

I send to you my workbook.

Markmzz

 

[sjc4]

Great! just got it. You guys are awesome.

Sjc4,

I send to you my workbook.

Markmzz