This user's problem is a textbook example of why traditional spreadsheets break under real-world collaboration. The core issue isn't a missing feature, it's a fundamental design flaw that forces people to choose between live data and manual context.
Here's what's happening: data validation pulls a static snapshot, not a living connection. When the source sheet updates, the new rows don't append to the bottom of the destination sheet, they overwrite the existing structure. The user's carefully added notes stay put, while the data shifts underneath them. The result is a spreadsheet that's technically accurate but practically useless. This isn't a user error. It's the tool failing to adapt to how people actually work: iteratively, with context, and across multiple sources.
The practical takeaway is uncomfortable but necessary. If you find yourself adding manual notes next to imported data and then manually re-syncing, you've hit the ceiling of what a static grid can do. The user is asking for cells that "move together." That's not a validation trick, that's a relational database behavior that spreadsheets were never designed to support. The workaround is to stop treating the destination sheet as a container for both live data and human annotations. Instead, keep the source data in one place, use formulas or scripts to reference it dynamically, and store your notes in a separate column that references a unique key, like a row ID, so the context follows the data, not the position.
This is why we believe the future of data management isn't about better validation rules or clever formulas. It's about tools that treat data as connected, not copied. The user's frustration isn't a minor inconvenience; it's a signal that the old model of "copy, paste, annotate, repeat" is costing time and introducing errors at scale. The solution isn't to find the right dropdown setting, it's to explore a system where syncing is automatic, annotations stay linked to their source, and the order of rows never breaks your work. Start by moving your notes to a column that references a stable identifier, not a row number. Then consider whether a truly connected tool, one that treats your spreadsheet as a live view of your data, not a static copy, might be the upgrade your workflow is asking for.