M
Maximilian Harmstorf
Hi all,
I need to get a solution for following problem.
I need to extract a table from a website, like this
http://www.cbot.com/cbot/pub/page/0,3181,1213,00.html and get it into a
useful format
Already tried it with the usual "import website" functions in Excel, but
neither is it working everytime, nor is it possible to add the data instead
of overwriting them all the time.
At the same time I would prefer it to delete unused rows and cells in the
spreadsheet after the import, but this is a minor issue.
It would be nice, if the format could look like this in the end.
17-Sep 16-Sep 15-Sep
24964 25131 25519
27450 27350 27200
27450 27350 27200
Every help is appreciated & thanks in advance
brgds
Max
I need to get a solution for following problem.
I need to extract a table from a website, like this
http://www.cbot.com/cbot/pub/page/0,3181,1213,00.html and get it into a
useful format
Already tried it with the usual "import website" functions in Excel, but
neither is it working everytime, nor is it possible to add the data instead
of overwriting them all the time.
At the same time I would prefer it to delete unused rows and cells in the
spreadsheet after the import, but this is a minor issue.
It would be nice, if the format could look like this in the end.
17-Sep 16-Sep 15-Sep
24964 25131 25519
27450 27350 27200
27450 27350 27200
Every help is appreciated & thanks in advance
brgds
Max