Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to let queried data overwrite the existiing data
34 views
Skip to first unread message
Lu Wei
Oct 23, 2012, 9:17:18 AM10/23/12
to
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
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
Don Guillett
Oct 23, 2012, 9:39:34 AM10/23/12
to luwe...@gmail.com
columns(destcol).clearcontents
Lu Wei
Oct 23, 2012, 9:53:04 AM10/23/12
to
On 2012-10-23 21:39, Don Guillett wrote:
> On Tuesday, October 23, 2012 8:17:30 AM UTC-5, Lu Wei wrote:
>> 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?
>
> On Tuesday, October 23, 2012 8:17:30 AM UTC-5, Lu Wei wrote:
>> 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?
>
> Try clearing the existing data first
> columns(destcol).clearcontents
>
Clearing the existing data will not work, resulting the cleared blank
> columns(destcol).clearcontents
>
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
Oct 23, 2012, 3:35:35 PM10/23/12
to luwe...@gmail.com
On Tuesday, October 23, 2012 8:17:30 AM UTC-5, Lu Wei wrote:
0 new messages