ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Import data with Webquery (https://www.excelbanter.com/excel-programming/389486-import-data-webquery.html)

Kolos

Import data with Webquery
 
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

Don Guillett

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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com