When Updating doesn't remove previous lines?

[Johny1900]

Hi,

I have a sheet which takes data from several sheets (they on there turn do some calculations).
Now in the main sheet I take the data of the articles and when I actualize it, it seems to add the latest SYNTAX results to the sheet.
Is there a way so it "resets/cleans" the data on the sheet and then adds the results to it?

Thx

 

[Johny1900]

Re: hen Updating doesn´t remove previous lines?

Anybody? Please.....
Is there some chebox where it always returns the latest result of the SQl syntax? So it just add the result, but first clears the rows?

thx

 

[Smitty]

Re: hen Updating doesn´t remove previous lines?

I think you need to be a bit clearer about what it is you're doing and what you're trying to accomplish.

 

[Johny1900]

Re: hen Updating doesn´t remove previous lines?

I think you need to be a bit clearer about what it is you're doing and what you're trying to accomplish.

oK , let me see:
I have in a spreadsheet a couple of sheets. And sheet one gets it data using a select from the DB.
I noticed that whenever I execute the SQL syntax, it just adds the rows.
And what it should do is remove all the rows of the screen and execute the select and then show me the new results. But now it just adds the new lines.

I am not sure, maybe I am doing something wrong. The doubled rows are always the same.

 

[Smitty]

Re: hen Updating doesn´t remove previous lines?

You can use code the pre-delete the cells. You can record a macro updating your query and add:

Cells.ClearContents

to the beginning.