i'd like to populate a spreadsheet Nr 1 based on the entries I made in a different spreadsheet.
Here's a description of my workflow: Based on a due date, I generate a calenderweek for specific Task A. E.g. 12.12.2018 -> CW 50. Based on this result, the calenderweek, I'd like to auto-populate the spreadsheet Nr 1 with the specific Task in a cell corresponding to the CW.
I hope I made this somewhat understandable.