Single Cell Web Query

S

Scott

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?
 
D

Don Guillett

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
 
D

Dave Peterson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert $ to actual numbers in an imported web query 1
Conditional formatting Entire Row Based on single Cell Value 5
Import Multiple Web Pages 3
Data Imports incorrectly 1
How to create a Web query in Excel? 1
Excel web query does not import table (from yahoo finance) correct 2
Referencing Cells in a Web Query 3
Change height and width of a single cell 3

Top