Hello,
Could someone help me with a worksheet change event, such that when a cell in column W (where W2=F2/G2, etc.) changes to 1, a today's date is posted in column L?
The column with the cell I will acutally change is F. So, when I change F2 to "4" (and G2 is "4"), W automatically becomes "1", and when W is "1", L should change to today's date (indicating the date when all 4 reviews on a paper came in).
Thank you,
Natasha