1

I have a bunch of formulas in my column's cells. I want to make a duplicate column with the same queries/formulas, and if I ever make a change in one of the cells in the column, it applies to all the same cells on the same row in the other columns.

How can I do this?

  • 1
    Welcome. Please describe your research in preparing for this question. A couple of things to clarify: Are you familiar with the difference between absolute and/or relative cell references and how they work in formulas? What kind of formulas appear in the first column? Would you please provide a sample screenshot of your data layout and give an explanation, with examples for your statement and if I ever make a change in one of the cells in the column, it applies to all the same cells on the same row in the other columns. Lastly, please include an example of a successful outcome. – Tedinoz Apr 3 at 22:06
  • You can try a script to update the new column's cells each time there's a change in the original column. – pjmg Apr 10 at 20:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.