So, as I understand it: The formula is stored in "formulas" but doesn'
need to do anything there. When copied to "data," it will be copied t
a cell other than B1, so it doesn't create a circular referenc
there??

If the formula isn't needed to do anything in "formulas," I woul
probably put an apostrophe at the front ('=...) so Excel will treat th
cell as text rather than as a formula. Then remove the apostrophe whe
you copy it to "data.

--
MrShort
-----------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...fo&userid=2218
View this thread: http://www.excelforum.com/showthread.php?threadid=46023