| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| Posting data from worksheet to webquery ?? | Excel Programming | |||
| Excel Import by Webquery | Excel Programming | |||
| Get Webpage data as text using VBA w/o Webquery | Excel Programming | |||
| PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ??? | Excel Programming | |||
Linear Mode
