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

 

[lionelnz]

I suggest you use Colo's HTML maker to show your SS.
http://www.puremis.net/excel/downloads.shtml

 

[janus67]

V E N U S MARS
date mercury 180 venus mercury 180 venus
date Venus 60 Mars Venus 60 Mars
date Jupiter 120 Venus Jupiter 120 Venus
date venus 3 Jupiter
not sure if this will turn out any better
I guess is comes down to-- will Excel sort using "symbols" ie grouping like symbols in the one column
Keith

 

[janus67]

I installed the HTML maker, but have no idea how to use it
just tried to copy & paste while it was open-- no good
Keith

 

[lionelnz]

On the tool bar of Exel you should have a menu item called HTML.

When you open your workbook & on the sheet that you want to postto the board click on HTMconvert to HTML gi to Board, select reply to this message & paste the into the body of th emessage. It will show a whole lot of HTML code.

Any added information regarding the worksheet can be added before or after the HTML code.

 

[janus67]

sorry when I run HTMLmaker 2.42, & convert-- it shows " compile error"
and does nothing

 

[lionelnz]

You could try uninstalling & reinstalling.

What version of XL & what Ooperating system are you using?

You could also try this altho a little more complicated to use.

http://www.excel-jeanie-html.de/html/down_en.php

 

[Peter_SSs]

sorry when I run HTMLmaker 2.42, & convert-- it shows " compile error"
and does nothing

Go to this link then you may have to scroll down just a little.
http://www.mrexcel.com/board2/viewtopic.php?t=92622#problems

 

[janus67]

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

 

[lionelnz]

This board does not allow you to post files but if you have a public site that you could upload your file to & then post the link here or there is this yahoo group http://tech.groups.yahoo.com/group/ms_excel/that allows you to post your file if you are a member of yahoo.