Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Copy a table from a web site, then manipulate the data?

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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default Copy a table from a web site, then manipulate the data?

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
tableright clickselect import to microsoft excel etc


--
Don Guillett
SalesAid Software

"Confused Rookie" wrote in
message ...
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting 2 colums of numbers and incremening them down blk&wht Excel Discussion (Misc queries) 10 October 9th 06 10:12 PM
data table based on data table BorisS Excel Discussion (Misc queries) 0 September 24th 06 03:11 PM
Copy table from web site bogi_js Excel Discussion (Misc queries) 1 February 27th 06 11:47 AM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM


All times are GMT +1. The time now is 08:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"