Another point regarding your macro ...
In my message #15 ... have asked you the following
" There is a rule you are imposing yourself ... which is not to be able to input the Month shown in the first six rows ..."
Are you aware of this feature ? And is it a valid requirement ?
You have not answered this question ....
Sorry ... but just re-tested the macro, at my end, and it is working fine ...
May be you have performed many tests with many files ...
Just close down Excel to clear your computer's memory ... and test again your test file ...
In the Message Box which accepts your months as names ... 
you should type in April for the start month and October for the end month ...
Hi,
In my opinion, the first step would be to clean your temp sub-directory ... in order to re-test your macro ...
Hope this will help
Message # 35 suggested a working solution ...
Since then ... have you managed to include it in your real-life workbook ...???
Once you have tested the formula, feel free to share your comments ...
Thanks in advance ...
Because ... very honestly ... have spent quite a while trying to decode all your criteria, arrows, colors, sheets, etc ...
and just want to give up ... !!!
... and for your Step 4
you could also test following formula, using your UDF :
=GetColor(INDIRECT(VLOOKUP($D$5,$CV$2:$CW$44,2,FALSE)),"index")Hope this will help
Thanks for your test file
For your Step 3, you could test following formula
=CELL("CONTENTS",INDIRECT(VLOOKUP($D$5,$CV$2:$CW$44,2,FALSE)))Hope this will help
Attached is your test file with a tiny modification of your macro
Hope this will help
Thanks for the info ...
Hopefully you have now reached the start line ...
A couple of remarks :
1. There is a rule you are imposing yourself ... which is not to be able to input the Month shown in the first six rows ...
Are you aware of this feature ? And is it a valid requirement ?
2. In order to Filter Dates, it would make a lot more sense to use Column D ... i.e Realistic Completion Date as the Reference ...
Does it make sense to you ... or not ...?
Great ... !!!
Do you mean this macro has never worked properly ...????
Can you give a simple example of what you would actually input as a Start Month and End Month in order to filter ...???
Thanks a lot for the file
This will make things so much easier ... to understand ... and probably ... to solve ...
What do you call Sheet 1 ...???
No problem ...
Back to message #2 ...
You do need to clarify what you actually mean by ' filter the first sheet ' ...
You can have a quick look at the Forum rules :
A long time ago, back in 2006, Ken Puls has explained this issue in a very clear way :
Hello,
Your macro deals with a worksheet named : TGS JOB RECORD
Difficult to guess if this is what you are calling " the first sheet " ... ???
Understand you need the Results macro to be modified accordingly ...
However, given the extreme confusion generated by your structure, could you add one complete example to illustrate:
1. All the inputs and criteria
2. The outputs and their location
Glad to hear you could fix your problem
Thanks for your Thanks ... AND for the Like 
Attached is your test file
Hope this will help