Posted by Jill-ann aka Jac on May 23, 2000 3:14 PM
I have a workbook in which I will have 10 worksheets. These 10 worksheets will be calculating results for 10 different markets. The FORMULA'S will be identical on each, they will just be pulling different data based their market (a reference to the market number). In the past, I would simply create the first worksheet and then copy it for the other 9 markets. However, with the CONSTANT tweaks that I am asked to make, I would forget to copy changes to all sheets or make some other equally simple mistakes that quickly jeopardized the integrity of the information. Now my question.
Is there a way to write a formula once and then refer to it in other formulas? For example, if the formula is "=sum(b1:b10)*a11", I would like to write that formula once, and then refer to the "XYZ" formula every time I needed to use it.
I'm not versed in visual basic, so if that's the only answer, I would appreciate if you addressed me as if I were 3 years old.
Thanks, in advance!