You really have to provide more information. the data can be matched
from the other sheets and filled in on one sheet, but it is not
entirely clear what you want. You usually get better answers if you
give an example. It does not have to be all your sheets, it can be
scaled down.

If you are looking at the same cell in both sheets and it is blank in
the other sheet, why not just add both together, as adding blank will
not change your formula, or if it produces an error if not completed

If(iserror(sheet1!ref),sheet2 formula,sheet1 formula)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=572460