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