| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Single Cell Web Query
When performing a web-based query it seems that the entire table is imported-
however, I'm only interested in the data in a single cell. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Single Cell Web Query
Don't think so. You can always hide columns/rows if ALWAYS in the same place or copy elsewhere with a macro. Post your url and I'll take a look -- Don Guillett Microsoft MVP Excel SalesAid Software "Scott" wrote in message ... When performing a web-based query it seems that the entire table is imported- however, I'm only interested in the data in a single cell. Is there a way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Single Cell Web Query
I don't do much with queries, but couldn't you put the results of the query on
its own worksheet, then just retrieve the value you want? Scott wrote: When performing a web-based query it seems that the entire table is imported- however, I'm only interested in the data in a single cell. Is there a way to do this? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Web Query for a Single Cell | Excel Discussion (Misc queries) | |||
| Query Named Range Return Single Column Value | Excel Worksheet Functions | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| Can Web Query retrieve a single HTML table cell? | Excel Discussion (Misc queries) | |||
| How to put a SQL query in a single Excel cell? | Excel Discussion (Misc queries) | |||
Linear Mode
