I want to create a printable, filtered “weekly/monthly view” from my annual schedule in Excel.

Hi @Treeva,

Thank you for posting your question in the Microsoft Q&A forum.

Based on your request, this can be achieved by using combination of filters, dynamic ranges and necessary features within Microsoft Excel. However, to help you resolve this issue, can you share some screenshots of your Excel data sheet so I can take a look to clearly understand the file structure to provide the most appropriate guidance for your concern.

Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.  

Thank you for your understanding and cooperation. I'm looking forward to your reply.

The Weekly Schedule worksheet looks exactly like what happens if there is a non-empty cell, probably containing a string of one or more blanks, somewhere in B5:O5 or A6:O11. If that is the case, you can solve the problem by selecting each area and pressing Delete.

Hi @Treeva,

Sorry for the late response.

I've created a same testing worksheet, and I want to confirm that the formula you're currently using is 100% correct.

However, if you received the error #SPILL! when using this formula, it means in the range for inserting information there is one or many cells that already have values inside (most likely a blank) so the formula cannot insert the results in there as Mr. Barry Schwarz did mention.

You can clear the cells by selecting all the data range from the header downward then going to Editing > Clear > Clear All or Clear Contents

You can try clearing the cells and proceed with the formulas to see if it works properly now. If you have any concerns or questions in the future, please don’t hesitate to reach out. Not only will I be happy to assist you, but all moderators in the Q&A forum will also do their best to provide support and guidance. 

We truly appreciate your time and cooperation throughout the resolution of this matter. I'm looking forward to your update.