LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Simplest way to auto update a spreadsheet with web info?

I would like to update a table similar to a stock price table but that has
other info involved, so we can plot prices versus different variables.

I have looked at Excel Web Queries, but not sure if this is the way to go,
or if even Excel is the way to go.

First, I would like to create a table(s) and each day automatically just add
a row to the top of the table with the information we need, and move the
existing data down a row.

If we get this accomplished, is there a way to set it up so that it can pull
different data from different sites to populate different cells? For example:
In Excel, have it put the date in cell A4, stock price from Yahoo in cell B4,
usage from another website in cell C4, etc?

Do we have to open or run something everyday to update the tables or is
there a way to automate the data gathering?

After reading all this, is this too much for Excel or do we need something
more? Preferably Microsoft, since we have free use of Microsoft software.

Thanks for your help!

Sincerely,

Just trying to keep The Man happy...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My spreadsheet will not update new info Confused? Excel Discussion (Misc queries) 0 November 18th 08 03:43 PM
How to auto update a spreadsheet with data from a .xls file? TriumphRM Excel Worksheet Functions 1 July 28th 07 03:24 PM
how do I set up a spreadsheet and auto update from another wksheet sm Excel Worksheet Functions 0 February 7th 07 04:25 PM
Can I 'auto update' my spreadsheet ? Rich Excel Worksheet Functions 5 January 4th 07 02:41 PM
Auto Update Info from Different Sheets? silencebreaking Excel Discussion (Misc queries) 3 June 12th 06 03:44 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"