How can I link two sheets together?
I am a communications and brand manager, and I have two sheets that I will be working from primarily. One is a Request Form, the other is a Master Calendar. These need to be different because the Master Calendar includes things such as company events to which I need to send a photographer for internal communications, and the Request form is for deadline-oriented tasks such as an appeals letter that the development department wants my marketing department to create. I want the request report to populate to the Annual Calendar.
I reviewed the video online, and it seems as though I can do this by creating a report, which I have done:
But the report is not allowing me to "link from cells in other sheet." What am I doing wrong? Am I doing this backwards? Do I need to create a report on the Annual Calendar as well?
Help Article Resources
Check out the Formula Handbook template!