=IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

On Fri, 14 Nov 2008 11:40:06 -0800, John Galt
wrote:

I'm having a brain seizure and can't remember. If a cell on sheet #1 has
someone's name typed in it, I want to display it on sheet#2, if it's blank I
want to display nothing...it's an IF statement with a TRUE / FALSE thing,
yes???

I can't seem to make it work.