I have a formula sheet and I want to duplicate it several times for different data sets. If I use = & # 39; Sheet1 & # 39; A1
in A1 of Sheet2, it will copy the value but formula.
Is there a way to copy formulas and all the cells of copied formulas will change if you modify the source cells?
Thank you!