Web Query Help...
 

I have a web query that works perfectly. I have a column to the right of the
query that references certain cells from the web query. The web query is
updated every day. However, the query does not fill the same number of cells
with data each day. One day there will be data from A1 to A53 but the next
day there will be data from A1 to A67. My cells that reference this data
works fine when the query returns data all the way to A67. However, if the
query returns data to A53 it works that day but the next day if the query
returns data to A67 all the cells after A53 give me a #REF! error. Is there
a way to setup my reference cells so they don't lose their reference? Thanks

if you don't understand what I am asking I can try and reword it. Just let
me know. Thanks

"Jambruins" wrote:

I have a web query that works perfectly. I have a column to the right of the
query that references certain cells from the web query. The web query is
updated every day. However, the query does not fill the same number of cells
with data each day. One day there will be data from A1 to A53 but the next
day there will be data from A1 to A67. My cells that reference this data
works fine when the query returns data all the way to A67. However, if the
query returns data to A53 it works that day but the next day if the query
returns data to A67 all the cells after A53 give me a #REF! error. Is there
a way to setup my reference cells so they don't lose their reference? Thanks