pivot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to take a copy of data on the web to a pivot tabel? ex. take a copy of
ford and fiat cars in bilbasen.dk... HOW!?
 
Import the data onto a worksheet
(Data>Import External Data> New Web Query)
Then, create a pivot table from the imported data
 
Hi. thanks.. but I already tried it. when I click the import button, to my
selected "zone" at the website, I dont get the information I asked for..

"Debra Dalgleish" skrev:
 
The problem is that the page you mention is already filtering a
database. When you make selections in the dropdowns, the page content
changes, based on a database elsewhere on the web server.

(At least that's how it looks; I know hardly any German.)

Debra's suggestion works if the html page has a table of data, and you
want to use that table as the pivot data source.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top