Recent content by mmuu

  1. M

    VBA - Display cell value if conditions met

    For reference, this is the formula I wanted to use: =IF(ISNONTEXT($H5),IF(AND(YEAR(J$2)=YEAR($H5),WEEKNUM($H5)=WEEKNUM(J$2)),$D5,""),"") Screenshot of how it looks when I run it is attached. As you can see, it's "close" but the formulas end up blocking the text from appearing. The formula...
  2. M

    VBA - Display cell value if conditions met

    Hello! I'm looking to make the leap from formula proficiency to VBA use and would appreciate some guidance. I'll try to explain my task in text, but have also attached an image: "Titles" (user entered text) in column A2:A4 "Timing" (user entered dates) in column B2:B4 Another "Timing" (fixed...
Back
Top Bottom