On 5/10/08 3:59 PM, in article ee899fc.7@[EMAIL PROTECTED]
"Walter_Ryan@[EMAIL PROTECTED]
" <Walter_Ryan@[EMAIL PROTECTED]
> wrote:
> Bob:
> Well, I tried the query route. The software I bought from Actual Tech to
> sup****t the query had more complex, unfathomable and less logical
instructions
> than what I have received from MS on this website or Excel manuals. I
futilely
> fought their download and implementation instructions for 3 days and
then
> complained about all the geek-speak in an e-mail and they agreed,
apologized
> and refunded my purchase payment to my CC. They then referred me back to
you.
> So I'm back to square one.
> There are numerous people with my same problem on the Mactopia site.
> They want just the current stock price. So do I. I refer to your
3/30/2008
> answer to Peter there as an example. If MS can send back the plethora of
> superfluous data they do on a query when all we wanted was the current
price,
> then why in the world can't they just send back the current price?
> It make no sense to me. Please tell me why.
> Your answer on redesigning the sheet slightly was equally confusing to
me,
> since I do not have your knowledge or computer skills nor do I
understand the
> nuances of hidden sheets and linking to them. What do I redesign in my
sheet?
> And is there some detailed written explanation of the procedures you
describe
> somewhere?
> I bought your newest 2008 Excel just as I have purchased every prior and
> subsequent version of it since 95. I have been a loyal MS customer with
each
> Office upgrade. I do not understand why my significant work in preparing
these
> 30 stock spreadsheets to my satisfaction has been relegated to the trash
can
> because of some unknown problem the company does not choose to address.
It
> just doesn't seem like nuclear physics to provide the option to split
out and
> return the quote to a cell by itself instead of sending all the extra
unwanted
> data on volume, dividends, etc., etc., etc. Please reply.
> Walt
I assume you addressing this to me. If not, I'll respond anyway. I must
reiterate and state that I am not a Microsoft employee, just a user like
you
are. I have no idea why the query is structured this way. If you want just
the price, then use a query for another website. The fact that a bunch of
information is returned for each stock symbol is a benefit, not defect.
Try
looking in help to see how to link data from one sheet to another. The
quick
answer is to select the cell where you want the result. Then type an equal
sign "=" and then click on the cell in another sheet that is the source of
the data. Return your queries to that sheet, and hide it.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
|
