Results 1 to 2 of 2

Thread: Put NA on week dates IN RANGE

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2020
    Posts
    10

    Put NA on week dates IN RANGE

    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.
    Attached Files Attached Files

  2. #2

    Thread Starter
    New Member
    Join Date
    Jun 2020
    Posts
    10

    Re: Put NA on week dates IN RANGE

    Anyone?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width