Is there a way when I paste new information in column A, I can get column B to auto populate down the column for new rows I added when pasting information in Column A?
Example --- I have A2:A10 with numbers, B2:B10 has the formula. I paste in new information from A2:A20, can B11:B20 auto populate the formula without having to manually paste the formula?
Example --- I have A2:A10 with numbers, B2:B10 has the formula. I paste in new information from A2:A20, can B11:B20 auto populate the formula without having to manually paste the formula?