Copy contents of fixed cell address on sheet that is refreshed via web query

[suprsnipes]

I'm having alot of trouble with the following.

I have a web query updating in the background and I want to copy the cell address below if it is not equal to "" from sheet cm to A1 on sheet 2 but I am having a problem. When the web query is updated and the contents of the cell address cm!A11 goes from being "" to containing data for some reason my formula is shifted down a cell to cm!A12 and so on. How can I work around this?

NB: I have tried using absolute values and I encounter the same issue.

Regards,
suprsnipes

 

[SydneyGeek]

Check the settings on the query table. When it refreshes one option is to insert new rows instead of overwriting existing rows. I think that is the issue for you.

Denis

 

[suprsnipes]

That was it exactly.

I now have the following option selected;

"Overwrite existing cells with new data, clear unused cells"

Cheers.