I am trying to complete this command (this would be a cell value on sheet 2): A1 (sheet 1) if K(sheet 1) is current date
Basically I want cells on sheet 2 to contain data from sheet one, only if Col K on sheet one has the current date.
Is there an actual formula to complete this action?
EDIT for claification: I want to get all items on sheet 1 with the current date in column K to report to sheet 2 as a daily report. I made the error of referencing cell A1. That was just the starting point. Basically if it is on sheet 1 with the current date, it will move that line to sheet 2 as a consolideted report with no lines skipped for the lines that do not have the current date.
Basically how do I get sheet 2 to not display "false" results.