V
vigfus
Aaaaaarg, i'm stuck...
I know how to make basic functions in Exel, i even made some really
complicated ones, but i think i need another approach to fix this.
I want to import a table from a webpage (easy, just make a webquery that
updates every now and then) then i want to take some of that information and
save to plot a graph, sort of like with the stockmarket.
This is my problem... i don't know how to do this. I need to copy the part i
want to keep progressiveley further away. I don't even know how to automate
the copying of one set of numbers, let alone how to make the procedure
"mobile". This is a graphic explanation of what i want to do:
http://img331.imageshack.us/my.php?image=stockmarket8zg.jpg
The red part is the raw data i can fetch automatically. The green is the
part i want to save from each dataset. You can see that i have manually
copied four parts into place and i want to keep pasting the new parts onto
the right of the green area.
Please help. If indeed this is impossible with Excel i would appreciate tips
on what software could do it.
Thank you.
I know how to make basic functions in Exel, i even made some really
complicated ones, but i think i need another approach to fix this.
I want to import a table from a webpage (easy, just make a webquery that
updates every now and then) then i want to take some of that information and
save to plot a graph, sort of like with the stockmarket.
This is my problem... i don't know how to do this. I need to copy the part i
want to keep progressiveley further away. I don't even know how to automate
the copying of one set of numbers, let alone how to make the procedure
"mobile". This is a graphic explanation of what i want to do:
http://img331.imageshack.us/my.php?image=stockmarket8zg.jpg
The red part is the raw data i can fetch automatically. The green is the
part i want to save from each dataset. You can see that i have manually
copied four parts into place and i want to keep pasting the new parts onto
the right of the green area.
Please help. If indeed this is impossible with Excel i would appreciate tips
on what software could do it.
Thank you.