Hi... when I enter a name (A2) automatically in B3 SEX, B4 BMI, B5 HEIGHT, B6 WEIGHT vice versa… should be generate.. . when we enter next name in cell A7 the Name of items(SEX,BMI,HEIGHT,WEIGHT) will generate in columns B (cells B8 SEX ,B9 BMI .B10 HEIGHT .B12 WEIGHT) Likewise CELLS A2,A7,A12 ....have names then corresponding cells of B columns genrerate the items name(SEX,BMI,HEIGHT,WEIGHT... If I delete the name in (exaple) cell A2 then cells B2,B3,B4,B5 would became blank . Simply if cell A2 is blank then B2,B3,B4,B5 would be blank… So when cell Ax has letters then cells Bx+1 =Sex, Bx+2=Bmi,Bx+3=Height,Bx+4=weight would be displayed, at the same If cell Ax is blank then Bx+1,Bx+2,Bx+3,Bx+4 would blank.. I neeeed that formula… Thank in advance…. In anticipation