Autofil a cell in the same row.
 

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

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
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mac5" wrote in message
...
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

This works fine...thanks a lot.

"Max" wrote:

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
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mac5" wrote in message
...
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

Glad to hear that !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mac5" wrote in message
...
This works fine...thanks a lot.