Hello. I have a database (db1) (which updates daily with new content) and I run a query from it to bring some content (based on filters) into another workbook(db2). One of the columns is populated with the word 'unreviewed' in each cell. When it is imported to db2 a macro runs to to make that column into a dropdown so the user can then change 'unreviewed' to 'reviewed ignore' or 'reviewed upload' another query is then to run to pick up all the 'reviewed upload' to a 3rd database to manage. How upon refresh of db1 to 2 do I stop the reviewed status being changed back to 'unreviewed'. So can I change db1 (those rows that have been extracted) after a refresh or as part of the query from db1 to db2 do I add an additional column with the reviewed status (having removed it from db1) then use that to get to db3, presumably then it db1 to db2 query won't see it as different and try to change it?