Copy a table from a web site, then manipulate the data?

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

Guest

I used a web sites drop down boxes to narrow down a product search. The
results of the search produced a table of values. I copied the table and
pasted it into a spreadsheet, but what I expected to be values turned out to
be a table with labels. (or numbers in "" quotes) Is there any easy way to
convert the image to a table of values?
 
you should post your url for assistance. You probably would like to use an
external query to do this. With my xl2002 I can place my cursor on the
table>right click>select import to microsoft excel> etc
 
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

How to Populate Data from a table to another 0
VBA - retrieve data on last create named range from previous inserted named range 0
Copy columns, but not hidden ones 3
Excel VBA code which copy data from a web page in excel 3
Look up table? 1
Pivot Table - copy specified Grand Totals 1
IMPORTING from Scottrade GAINSKEEPER table? 3
Lose formatting on pivot tables 3

Back
Top