Hi All,


I've struck upon what seems to be impossible to me.

So here I have the main calendar of employees and their availability.

ROTA.PNG

Here we have a list of employees and what's their availability throughout the year.

What I'm trying to do is to "extract" only those who are available (Active) on a specific day and be able to see the row (up to, but not including Column I) on a separate sheet.

This is the code that I'm using at this point.

Code.PNG

As you can probably already tell, the code copies an entire row, which is not desired, however it successfully tracks the "Active" people and places them in a separate sheet. Nonetheless, the goal is to have the process as automated as possible.

In the "daily" sheet where all the "active" staff will be located they will also have hourly tasks allocated next to their names, and therefore once the data is "extracted" it overwrites all the useful stuff in the "daily" sheet.

How can I work around this and possibly automate the process - so that when changes are made in the "yearly" sheet would automatically reflect in the "daily" sheet?


Many thanks everyone.

SS