I have a spreadsheet that has an external data connection to an Access database file. Every 5 minutes, it refreshes the data. I created a column to the right of this linked data. I wanted to have a drop down menu where the user could essentially list that particular row as "ready" or "not ready".
The problem I ran into is, when the data refreshes every 5 minutes, that data can get shifted to a new row, but the column I created to designate whether or not that particular row is "ready" or "not ready", does not move with the rest of the data.
Is there a way I can link the data so it moves as the data gets updated? the data it pulls is filtered for "today", so it changes constantly.