How to let queried data overwrite the existiing data

  • Thread starter Thread starter Lu Wei
  • Start date Start date
L

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?
 
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
Click to expand...

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

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.
 
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
Click to expand...

Send me your file if you like.
 
Back
Top