Hi There -

I have two Excel workbooks where one is supposed to be the "source" for
information in another which we will call "target". I would like to be able
to say if the value of the cell is blank in the source it will show up in the
target as N for no and if there is a value in the source cell the
corresponding target cell displays a Y for yes.

Does anyone know how to do this?

Many thanks!