How to let queried data overwrite the existiing data

[Lu Wei]

When a query is returned, it inserts a new range of data making the old
data move rightward. But I want the new data just overwrite the existing
data, to avoid formula invalidity. Could it be done?

 

[Don Guillett]

When a query is returned, it inserts a new range of data making the old

data move rightward. But I want the new data just overwrite the existing

data, to avoid formula invalidity. Could it be done?

--

Regards,

Lu Wei

PGP key ID: 0x92CCE1EA

Try clearing the existing data first
columns(destcol).clearcontents

 

[Lu Wei]

Try clearing the existing data first
columns(destcol).clearcontents

Clearing the existing data will not work, resulting the cleared blank
columns moved to right by query returned cells. Deleting the existing
data seems should work, but the referenced column in formula (in another
sheet) will become #REF! and cannot recover to original name after query.

 

[Don Guillett]

When a query is returned, it inserts a new range of data making the old

data move rightward. But I want the new data just overwrite the existing

data, to avoid formula invalidity. Could it be done?

--

Regards,

Lu Wei

PGP key ID: 0x92CCE1EA

Send me your file if you like.