View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Import data with Webquery

Import to the "Data" sheet and use a macro to copy the desired info to your
"destination" sheet.

sheets("data").range("a2:x4").copy sheets("destination").range("a2")

--
Don Guillett
SalesAid Software

"Kolos" wrote in message
...
Hi All,

I need to import data from web pages but I need only data from certain
cells, not the whole table. Excel lets me select tables only. Can anyone
suggest a solution for selecting individual cells as source?

Thanks.

Kolos