First, I am working on two spreadsheets, say sheet 1 and sheet 2.
Sheet 1 contains raw logistics data and the sorted data source to retrieve in Sheet 2. Sheet 2 is the working sheet where everyone could see the sorted data from the Sheet 1 (using query formula) so that they can put some input next to it. So, the spreadsheet consists of two parts of information, the retrieved data using the query formula (from sheet 1) on the right until column K and the manual input on the left from column L onwards.
Now the problem is whenever I add any row in Sheet 1, the data that were manually input in Sheet 2 got messed up. For example, the loading/unloading time at the event venue should be aligned to the loading/unloading time at the warehouse.
I would like to create a tickbox or something that to fix the manual input (warehouse) and the retrieved data (Event venue) together after finishing the input. So that whenever retrieved data move, it moves along together. Is it possible?