View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default What Tasks Can Be Automated?

Results:
Temporarily down for maintenance.

What do you mean by invert? (it might be obvious by looking at the link,
but as I said, the link isn't working right now).

Small sample of what you get and what you want.

--
Regards,
Tom Ogilvy

John Gregory wrote in message
...
Data will come from the Federal Reserve Bank of St. Louis (sample:
http://research.stlouisfed.org/fred2/series/MZMSL/30 .... the data from

the
download area).

What's the function that I should use to invert the downloaded data once
it's in columnar form? If all goes well, I plan to toy with this later
today.

I apprecaiate the help.

"Daniel Klann" wrote in message
...

Hi John,

2, 3 and 4 can all be done. Where are you downloading the '50+ data

points'
from? That's probably also possible but depends where you're getting

the
data from. Your best bet is to record a macro and look at the code.

You
can then ask questions about how to modify it or experiment yourself.

Regards,
Daniel
-----------------------------------------
Website : http://www.danielklann.com
Favourites Add-in for Microsoft Excel -
http://www.danielklann.com/excel/exc...tes_add-in.htm
-----------------------------------------


"John Gregory" wrote in message
...
I need to...
1) download 50 + data points each week to a worksheet
2) invert the order of these numbers
3) place then into a worksheet where they can be highlighted with

the
cursor so they can be charted (or can this be dome right on the 1st

spread
sheet?)
4) graph a chart

Can all of this be done with one macro? IF not, which parts can?