Table Row Data validation I have 3 columns with data validation Column 1,3,5. then I create a new row in the table column 1,5 have the data validation in it but column 3 does not carry the data validation down.
Thank You
What I have tried. When I add a row at the end of the table Column 1,5 carry down but not 3. If I create the row anywhere else in the table all 3 data validations carry down. I have deleted the data validation and recreated no change. Any help in fixing this is greatly appreciated. one last thing all 3 have similar setting including the formula in the data validation. I have tried different formulas still no change.
Thank You