mercredi 25 mars 2020

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

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