I am doing some homework in a class that I have to insert tables/data and whatnot from a web query into an excel worksheet.
I was wondering if there was anyway to go about doing this on a macbook?
In the Departures sheet, in cell A1, create a Web query to the departures table on this Web page: http://media.pearsoncmg.com/ph/bp/bp_myitlab/departure_schedule_files/departure_schedule.htm. Maintain full HTML formatting before importing the table.
Hint : On the DATA tab, in the Get External data group, click From Web. To specify the formatting, in the New Web Query dialog box, click Options.
I was told it cannot be done on a macbook by some other kids in class. I have researched and tried the ways up inserting the URL into a file and saving it and trying to do it from a text file, but it will not work sadly.
I was wondering if there was anyway to go about doing this on a macbook?
In the Departures sheet, in cell A1, create a Web query to the departures table on this Web page: http://media.pearsoncmg.com/ph/bp/bp_myitlab/departure_schedule_files/departure_schedule.htm. Maintain full HTML formatting before importing the table.
Hint : On the DATA tab, in the Get External data group, click From Web. To specify the formatting, in the New Web Query dialog box, click Options.
I was told it cannot be done on a macbook by some other kids in class. I have researched and tried the ways up inserting the URL into a file and saving it and trying to do it from a text file, but it will not work sadly.