Automation Copy row
I have two sheets with the same column names. On sheet one, one of the properties of the column is a dropdown (Single select). On sheet two, the column with the same name has its properties set to Text/Number. If the column properties are different, will it still copy over the data that is in that cell?
Best Answer
-
It will copy over the data, but it may create a new column on the far right of the sheet to match the column type. I am not sure. Have you tested it yet?
Answers
-
It will copy over the data, but it may create a new column on the far right of the sheet to match the column type. I am not sure. Have you tested it yet?
-
@Paul Newcome Sorry, I should have just tested out before asking the question. It does only pull over the row's data, and it does not make a new row. Thank you
Help Article Resources
Categories
Check out the Formula Handbook template!
