I need to move Data from Cell A2 Sheet 1 to next available Cell A Sheet 2 if a date is input into Cell J2 of Sheet 1. I used the following if statement.
IF(isdate(Sheet1!J2),Sheet1!A:A,)
The problem is that if there is data in sheet 2 A2 then data does not transfer. So I need to modify statement to go to the next available Cell A
Aucun commentaire:
Enregistrer un commentaire