Autofil a cell in the same row.

M

Mac5

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
 
M

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 ..
 
M

Mac5

This works fine...thanks a lot.

Max said:
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 ..
--
Rgds
Max
xl 97
Click to expand...
 
Top