Web query problem

[babycody]

I have a web query set up to import several pages into one column. The problem I am having is that sometimes the amount of information imported changes in length. When that happens one query can write over another query. This leaves several rows of information cut off of the query above it. Is there a property setting I should use to solve this, or some other solution?

Example:
Today I used A3 for a query. The results took up 8 rows. I started a new query in A12. The next day I refreshed. However the query for A3 took up 10 rows this time. That would make the results end at cell A13. Since the second query starts on A12 they wind up overlapping. This results in the last line of the first query being cut off.

Thanks for any help on this guys!

 

[tusharm]

Why not put the results in adjacent or close-by columns?

I have a web query set up to import several pages into one column. The problem I am having is that sometimes the amount of information imported changes in length. When that happens one query can write over another query. This leaves several rows of information cut off of the query above it. Is there a property setting I should use to solve this, or some other solution?

{snip}

Thanks for any help on this guys!

 

[babycody]

I thought about that, but I am using vlookup and a fuzzyvlookup. The web query is my source. I'm sure I could do it with several columns, but the formulas would probably be much more difficult to deal with. It is working fine now at any rate. Thanks for the input.