I have just discovered the Web Query option where i can set excel to import data from a website-brilliant! I now want to transfer that list of data to another worksheet in order to keep an historical ongoing daily record. So page one is generated daily from the web and page two is added too each day with an extra row. I know how to link the cells from one sheet to another, but how can I continue with more data on subsequent days.
That's going to require some code, VBA, to accomplish. Probably needs to occur at the same moment the web-update occurs, the data comes in and the key data points get copied to your historical reference page.
Paste your question in the Programming forum to get the fastest response.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you i'll try that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks