jazz2409
07-22-2020, 12:35 AM
I have a sheet called Special Considerations where I need to check the dates that the people will not send data. The projects, client names and types will have multiple entries over time. I need to be able to check the dates and put NA on dates that they did not send data based on Project Name, Client Name, and Type. If the specific Project and Client and Type has an entry in the Special Considerations sheet and they have no data in the raw sheet, the week(s) will be tagged as NA. If they have no entry in the Special Considerations sheet and they have no data in raw sheet, they will be tagged as N. If they have data, they will be tagged as Y.
The attached file shows the current output of my macro (current sheet) and the should be sheet shows what the output should be.
Also posted here https://www.excelforum.com/excel-programming-vba-macros/1322448-put-na-on-week-dates-in-range.html
The attached file shows the current output of my macro (current sheet) and the should be sheet shows what the output should be.
Also posted here https://www.excelforum.com/excel-programming-vba-macros/1322448-put-na-on-week-dates-in-range.html