pivot
 

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
(DataImport External Data New Web Query)
Then, create a pivot table from the imported data

Louise wrote:
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!?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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:

Import the data onto a worksheet
(DataImport External Data New Web Query)
Then, create a pivot table from the imported data

Louise wrote:
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!?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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/
_______


Louise wrote:
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:


Import the data onto a worksheet
(DataImport External Data New Web Query)
Then, create a pivot table from the imported data

Louise wrote:

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!?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html