Thanks for your thoughts Bill - I know what you're saying about avoiding
circular refs. I think in this case they would be ok, however. The
scenario is that I have on one sheet a list of 810 individual items.
These items are stored in 10 drawers of 9x9. Hence Sheet1 is the whole
list, then I have a further 10 sheets to represent the layout and
contents of each drawer. When an item is removed / altered I would
normally enter this in the Sheet1 list, so all is fine. I just wondered
if, on the odd occasion if I altered it in one of the other sheets, if I
could get Excel to effectively do the reverse and update the Sheet1 ref!
there are no real formulas, just an ='Sheet1'!$E2 type formula in each
cell of sheets 2 to10. Pretty much a glorified filing system really!


--
R.Hocking
------------------------------------------------------------------------
R.Hocking's Profile: http://www.excelforum.com/member.php...o&userid=31092
View this thread: http://www.excelforum.com/showthread...hreadid=507618