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/
_______
 
You must log in or register to reply here.

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

Access Remove rows based on multiple fields 2
Pivot Chart Legend editing? 4
Showing all rows in a pivot table 2
Cannot change data source for copied charts 1
how to persist pivot chart data 1
Pivot charts filter field in 2007 3
Count Unique Items with Multiple Criteria 12
Pivot Table: deleted source data 1

Back
Top