Hi Everyone,
I’m having issue with my transferred data. I selected automatic transfer once a day, 11PM, M-F. However, I’m quite confused if there’s something wrong with my set up, cause the updated data don’t replace the original data but it only adds the updated one after the original data.
For example,
I transferred this data today from another sheet:
- Apple
- Banana
- Mango
- Pineapple
The ff day the updated data must be:
- Apple
- Banana
- Mango
- Pineapple
- Star Apple
However, the transfer looks like this:
- Apple
- Banana
- Mango
- Pineapple
- Apple
- Banana
- Mango
- Pineapple
- Star Apple
The updated data were placed after the original file to which there’s no need for me to keep the original but to show only the updated file.
How to set it up properly?
thanks for help