Excel table column validation next row
- by Kamlesh Doctor
I made a table with first column formatted to DATE. In the first row I entered the date manually. In SECOND column I entered validation of date = previous date.
I copied this table 8 times. In 5 tables when row is added the validation also appears in the next cell, but in 3 tables it does not. How can I correct this?
I tried making a similar new table but the validation condition does not appear in the new row.
Please reply.