By Colette Frechette at May 04 2019 15:55:39
Linking by creating a formula. With this method you can create an inter_active link between worksheets or workbooks. The linked cells do not need to be in the same location on all worksheets. You can perform any math operation while creating the link. For example, you could take a figure from one worksheet, multiply it times a figure form another worksheet and then subtract a number from a third worksheet. You can use this method to link cells across worksheets or workbooks. One disadvantage of this method is that it is time consuming because you are working with one cell at a time. Using named ranges can assist with this method of linking and make it easier to read your formulas once they are created.
I have said "Don't Use Worksheets" about every way there is to say it, and each time I have included solid brain_based, researched reasons for this statement; and yet, I know that many people will ignore the science in favor of the convenience. It is very difficult to fight the tide when there are so many internet sites pushing worksheets at parents, and so many reputable textbook companies doing likewise. It is difficult to remember the reasons to avoid them when one has very little time to devote to working with math. Worksheets just seem so much easier than doing things any other way. Can they really cause harm?