•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
rows don't follow unique value
Guys, I need help with an Excel issue.
I have a master sheet with an auto-updating formula that pulls unique rows by ID from 3 other sheets.
The next columns contain dropdowns (data validation) and comments that users manually update. Once they select a dropdown, the formula is replaced by a value (can’t avoid that).
The problem: when new data is added to the source sheets, the formula refreshes and inserts new rows in the middle, but the dropdowns/comments don’t move — they stay on the old rows and no longer match the correct ID.
Is there a way to make each row (including manual dropdown values) follow its unique ID when the formula updates?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#google sheets
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#row zero
#Excel
#master sheet
#auto-updating formula
#follow unique ID
#unique rows
#ID
#dropdowns
#data validation