Reverse column data in EXCEL

[travsab]

Each month i have to copy a column of data listed from Jan to Dec to another column listed Dec to Jan.. the only way i know how to do this is to type it in. Is there an easier way? thanks

 

[GlennUK]

Why don't you sort it beforehand? So that it matches the order of the target area, then it's a simple copy and paste operation.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[bluedragon2]

If it has to stay in that format, record a macro of what you copy.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...