Converting to and from Named Formulas
There are probably easier ways. not easy but easier, but it would help to
see an example formula or two so that we could make a suggestion.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
wrote in message
ups.com...
Hi,
I have a spreadsheet that has lots of Named Formulas (to ensure
consistancy and avoid errors). Each formula refers to data in the three
rows directly above it (i.e. in the same column). The formula is
repeated further down in each column referring to more data.
I've been asked to insert a new row into each set of data, however when
I do this the named formulas don't automatically adjust for it in the
way that a directly inserted formula would i.e. the new row is
referenced when I'd rather point to the original cells. I presume this
is due to the fact that the formulas are relative rather than absolute.
Since the formulas are very complex I don't want to manually adjust
them in the Named Range box. The only thing I can think of is to
convert them all to normal formulas, insert the new row, then convert
back to named ranges. Is there way to sort this out?
Best Regards,
CalumMurdo Kennedy
|