This video is a continuation of my original moving data in Google Sheets video. If you have not seen that one, go watch it here for a full explanation of the basic script: https://youtu.be/ShcdwNh7wD0
Thank you Beckie for pointing out that the formula is not correctly updating to the correct cell reference when it gets moved. I updated the script on the template (link below), but I also have the full updated script in the comments below. I will be remaking this video shortly with the updated code.
If you want to make a copy of the Google Sheet & script I demoed in this video, you can do that here: https://bit.ly/47e3ciN
If you want to get more in depth (such as handling when the tab name is not the same as the dropdown, using a checkbox, or even sending an email alert), check out the part 2 of the original video here: https://youtu.be/0Up8bqnfttA
As always, thanks for watching and don't forget to subscribe!
