For work, I have a master spreadsheet getting new data monthly. At the beginning of each month, I’d like to distribute this data between different spreadsheets so that specific people can work on it. The issue is that in the child file, using append query, the modifications made the previous month are lost. Is there any way to use “append” without loosing data knowing that:
- the master file gets new data every month ;
- each child file has to have only one spreadsheet and new data has to appear at the end of the data of the previous month
Answer
Attribution
Source : Link , Question Author : Bastien Sgls , Answer Author : Community
