Autofil a cell in the same row.

[Guest]

What I would like to do is autofil a cell with hardcoded name when a cell on
the same row is updated. I.E. if data is entered in cell B2,B3,B4 ETC. then
the 'hardcoded name' will be placed in B1

 

[Max]

Not sure, but you could try something like this in B1:
=IF(COUNTA(B2:B10)>0,"hardcoded name","")

If anything is entered in any cell within B2:B10,
B1 will display: hardcoded name
otherwise B1 will remain "blank"

Adapt the range to suit ..

 

[Guest]

This works fine...thanks a lot.

Not sure, but you could try something like this in B1:
=IF(COUNTA(B2:B10)>0,"hardcoded name","")

If anything is entered in any cell within B2:B10,
B1 will display: hardcoded name
otherwise B1 will remain "blank"

Adapt the range to suit ..

 

[Max]

Glad to hear that !
Thanks for the feedback ..