sorting help required

[janus67]

hello, I have a page of planetary symbols (astrology) in 3 columns (A,B,C ) in date order, that I'd like to copy across on the same line (date) ,to a designated column on the same sheet, in order of the ColD symbol
it won't show here properly as there's no astro font, just tried it.
eg
A B C D E F
date Mercury 180 Venus Mercury180Venus
" Venus 60 Mars Venus 60 Mars
" Jupiter 30 Venus Jupiter 30 Venus

here, we have Venus copied to same line in ColE
Mars " " " ColF
could I have some advice please on how to sort the columns
if it helps, Cols B,C & D themselves could be resorted instead into the order of the ColD symbol-- so I'd have colA, date-- the B,C,D sorted by D, into about 8 Cols to the right
thanks Keith

 

[Peter_SSs]

I look at the debug notes but I don't seem to have those references
I'm running XP but only have Excel 2000
thanks anyway
Keith

Keith

In the link I provided there was a further link to this thread. Did you check it out too?
http://www.mrexcel.com/board2/viewtopic.php?t=107231

 

[janus67]

thanks lionelnz, i've joined the yahoo group and try that way
keith

 

[lionelnz]

Alright Keith. I will keep an eye out foryour post there.