Copying Cells to another sheet, formatting
Hi,
I am using a form to input data into a master doc and then have an automation to copy to another sheet for data manipulation.
2 issues-
1- When the cells are copied to the destination sheet (Data Manipulation) They do not take the next row, they go to a random row. How do I get them to take the next spot? This happens on some of my sheets but not all.
2- When the cells are copied to the destination sheet (Data Manipulation) they do not populate a formula that I have in the far right column. How do I make that formula apply to new rows added?
Thank you!
Best Answer
-
First: The rows will be copied to the first UNUSED row in the new sheet. Even if a row is blank, if it previously had data in it before, it is considered used and will be skipped. Make sure to delete the rows themselves and not just the data from the cells in the row.
Second: Try converting the formula to a column formula.
Answers
-
First: The rows will be copied to the first UNUSED row in the new sheet. Even if a row is blank, if it previously had data in it before, it is considered used and will be skipped. Make sure to delete the rows themselves and not just the data from the cells in the row.
Second: Try converting the formula to a column formula.
-
Hi Paul,
Thank you very much, that fixed it.
Not if someone else is struggling here, Right click on the cell that has the formula and click "Convert to column formula"
-
Happy to help. ๐๏ธ
Here is some more info on Column Fomrulas including a few limitations:
.
