Dear Forum users,
Already a few days I am looking for a way to solve my excel question. I hope someone on this forum can point me in the right direction.
At the company I work for, we have 2 excel files. One file has a calendar containing all the holidays of about 50 employees, and is filled in by a colleague of mine.
After filling in, she manually fills in the holidays in my excel file, a calendar containing a schedule of which employee is working for which customer.
I am looking for a way to combine the 2 excel files into one file, where the holiday sheet is the master version, and the scheduling sheet is the slave. When my colleague fills in the holidays in her list the corresponding cell in mine list, has to be overridden with the value 'holiday'. Whatever I fill in my schedule does not matter and should not be displayed in the holiday calendar. I should not be able to override a cell containing "holiday" in my file.
I have played around with queries and now have a functioning "master" sheet. Whatever I will input in the master will show in the Slave sheet. But I need to get it to a point that if I input data into my slave sheet, this data does not get over ridden by the blank cells of my master sheet.
I hope this makes sense, if not, I have an example that you can download from following link:
Google Drive - Schedule + holiday Excel Sheet
Thanks in advance for anyone taking the time to help me.
Regards,
Sybren
Already a few days I am looking for a way to solve my excel question. I hope someone on this forum can point me in the right direction.
At the company I work for, we have 2 excel files. One file has a calendar containing all the holidays of about 50 employees, and is filled in by a colleague of mine.
After filling in, she manually fills in the holidays in my excel file, a calendar containing a schedule of which employee is working for which customer.
I am looking for a way to combine the 2 excel files into one file, where the holiday sheet is the master version, and the scheduling sheet is the slave. When my colleague fills in the holidays in her list the corresponding cell in mine list, has to be overridden with the value 'holiday'. Whatever I fill in my schedule does not matter and should not be displayed in the holiday calendar. I should not be able to override a cell containing "holiday" in my file.
I have played around with queries and now have a functioning "master" sheet. Whatever I will input in the master will show in the Slave sheet. But I need to get it to a point that if I input data into my slave sheet, this data does not get over ridden by the blank cells of my master sheet.
I hope this makes sense, if not, I have an example that you can download from following link:
Google Drive - Schedule + holiday Excel Sheet
Thanks in advance for anyone taking the time to help me.
Regards,
Sybren