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]

anything helps!

thanks

 

[Desu Nota from Columbus]

can you show the before and after results of what you want?

Im not quite clear based on your comments

 

[sjc4]

yeah, i'll put the after example right now. thank you

 

[sjc4]

this is the after example. the before example is at the top of the thread. you see, with the right vba or macro i should be able to align the two rows by date and percentage so i can check their accuracy.

 

[sjc4]

to make the before and after easier for some:

Note: I am trying to align the two tables so i can compare their dates and return percentage side by side. i have about 300 sheets like this. Thanks again!

BEFORE

AFTER

 

[sjc4]

well, do you recommend i try a VBA or a macro?

 

[Desu Nota from Columbus]

This is way outside my level of VBA. The answer is definitely VBA (which is the program you use to write macros), but I do not possess the know how to do this.

It will be too complex for me.

You will have to associate Mon1, Mon2, Mon3, etc. to the middle of your date-- 01, 02, 03

Then do the same thing for the year Cy 2005 to 2005 and use these two criteria to return the value.

INDEX combined with Find/Match.....and a whole bunch of other stuff

 

[Desu Nota from Columbus]

Can you email me your spreadsheet? I can try to figure it out.

no promises though!

 

[sjc4]

i know, this is a very complex problem... but it will make my life much easier if i figure it out. i'll VBA a shot and do some googling.

i could email you an example sheet. does that work? pm your email.

This is way outside my level of VBA. The answer is definitely VBA (which is the program you use to write macros), but I do not possess the know how to do this.

It will be too complex for me.

You will have to associate Mon1, Mon2, Mon3, etc. to the middle of your date-- 01, 02, 03

Then do the same thing for the year Cy 2005 to 2005 and use these two criteria to return the value.

INDEX combined with Find/Match.....and a whole bunch of other stuff