Hello!
I'm trying to create a macro that searches for the most recent data (should be either yesterday or today) and copies it to another sheet under "AM', "NOON", OR "PM". Alternatively, a piece of code that searches through data, identifies the most recent one, and places it in the right box. Currently this does what I want, but it only scans one line. How do I get it to scan through the three most recent entries (O33:O35) and pick out the AM one? Using the range in lieu of specific points didn't work.
Thank you!!=IF(AND(TODAY()-1=$O$33, $P$33="AM"), $X$33, #N/A)
Bookmarks