I own a party rental company and we have 2 forms we use for our weekly schedule;
1st form is a google sheet we duplicate every week for our staff schedule and 2nd form is a google document we use for our truck delivery schedule that we also duplicate every week. I like using google sheets and google docs bc our staff can view and edit them remotely.
I want to be able to copy a new blank google sheet each week and as I copy my text information into that weeks schedule (the google sheet) it will auto populate the text into specific parts of the new google document thus saving me the time of copying and pasting everything which is tedious since we sometimes do over 20 parties per week.
I dont want it to auto populate both ways so when I make changes to the google document I don't want it to also make the changes back to the google sheet.
See 2 attachments of both forms we use.