pivot

L

Louise

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

Debra Dalgleish

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

Louise

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:
 
J

Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Power Pivot. Yikes. 0
Excel does not accept text format! 0
Pivot Table cell values 1
Write back from pivot table 1
Write back from pivot table 0
pivot table missing rows? 0
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top