Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
an excel dunce pleads for help
ok, i have spent the past 8 hours or so trying to do this very simple task. i have even followed instructions from other posts, but do not seem to get the result i am looking for(made all the more frustrating by having done it successfully before) all i want to do, is very simply, automatically sort a table based on column D. thats it. my worksheet has dde links that import stock prices, and i want to sort them automatically as they change throughout the day without my intervention... can anyone help? *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
an excel dunce pleads for help
Mebane,
You haven't said what's going wrong. I'll guess that column D contains the links, and it isn't putting them in the correct order. As a wild guess, I'll suggest taking a good look at them. Are there extra characters, perhaps, that shouldn't be there. Use =len(D2) to test. Are you getting text instead of numbers. Use =ISNUMBER(D2). I guess I'll stop guessing. You should use a descriptive heading. Maybe "Trouble sorting with links." -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Mebane Faber" wrote in message ... ok, i have spent the past 8 hours or so trying to do this very simple task. i have even followed instructions from other posts, but do not seem to get the result i am looking for(made all the more frustrating by having done it successfully before) all i want to do, is very simply, automatically sort a table based on column D. thats it. my worksheet has dde links that import stock prices, and i want to sort them automatically as they change throughout the day without my intervention... can anyone help? *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|