Column X and Y contain values which can be changed as they are pulling from data validation.
I have a macro set up which automatically adds new rows of information to this worksheet. Currently new rows are added with the range A:V
The formula and value in column W will automatically copy down when a new row is added. I would like to do the same with columns X and Y. The value that is copied down (e.g the choice of values through data validation) is not important as it will be selected by the user once the new row is added.