https://docs.google.com/spreadsheets/d/1hbQu0HmG_S_P-G8-e0XTDrKrKNg46P0_zEEPRL9738g/edit#gid=0
Hi, above link is my sample of google sheet. In sheet "MASTER LIST" I have all of item list from various of customer. But I need to filter some criteria into "Sheet2" to ease my staff to know which item to update into system where I use some formula to do it. But my problem is in "Sheet2" there is an additional column which is "Updates". If I add some data in "MASTER LIST" in between of existing row data, the data in column "Updates" of "Sheet2" will not sync to the data in Column A,B,C & D. Can you help & teach me how to make it done ? Thank you in advance.