C
colin
Hi,
I need to create a workbook that references multiple websites and have each
website display on individual worksheets.
I would like to get the external data by referencing a cells content that
provides the web address of the external data.
The external web addresses are as follows (example):
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=1
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=1
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=12
As you can see the addresses are page 8,9,10 etc
I can import them using the wizard in excel 2007 manually on each sheet but
it would be easier to reference the address on a worksheet as I can just drag
the reference down to increment the page number.
Any help would be much appreciated
Kind regards
Colin
I need to create a workbook that references multiple websites and have each
website display on individual worksheets.
I would like to get the external data by referencing a cells content that
provides the web address of the external data.
The external web addresses are as follows (example):
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=1
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=1
http://www.samknows.com/broadband/llu-league.php?filter_field=region_name&type=aol&page=12
As you can see the addresses are page 8,9,10 etc
I can import them using the wizard in excel 2007 manually on each sheet but
it would be easier to reference the address on a worksheet as I can just drag
the reference down to increment the page number.
Any help would be much appreciated
Kind regards
Colin