My table keeps changing my cell value after saving

[ashley12]

Hi everyone,

I have a query table in my spreadsheet. I added a column and put "No" in every row (See attached picture for a simplified example). So when the query is refreshed and add more rows, new rows will also have "No" as their starting value. And that's exactly what I want.

Then when the user interact with the spreadsheet, I use some VBA code to update certain cells of the column to "Yes". The problem is whenever the query is refreshed, all the cells in this column changed back to "No".

Do you know why this happens and how to resolve it?

Thanks so much!

 

[Anthony47]

Do you know why this happens and how to resolve it?

I'd say that you have a query that does its job...

You should extract from the query results the information you are interested in and modify this copy; and of course you need a macro, not formulas.

Bye

 

[ashley12]

Hi Anthony, I forgot to mention that I added the column onto the spreadsheet not the query, so I'm not sure why it keeps changing back. And no I don't use any formula, I just put "No" as a plain value.

 

[Anthony47]

Probably the query range extends to the cells you are using...
I suggest that you create a copy of the query results, in a separate sheet, and work on these datas

Bye