Web Applications Asked by Romulus Urakagi Ts'ai on August 20, 2020
I have a sheet of formulas, and I want to duplicate it several times for different data set. If I use ='Sheet1'!A1 in A1 of Sheet2, it will copy the value but the formula.
Is there a way to copy formulas, and all copied formula cells will change if you modify the source cells?
It's not 100% clear to me what you are asking. But your best approach may be to simply right-click the original sheet name at the bottom (in the tab) and choose "Duplicate." This will create a new sheet with all of the same formulas in it.
You can also select the range of formula cells from Sheet1, hit Ctrl-C to copy to clipboard, then click in the upper left cell of the same range in Sheet2 and hit Ctrl-V to paste. The formulas will be pasted exactly as they were in the Sheet1.
Answered by Erik Tyler on August 20, 2020
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP