# Need help auto generate columns

#### pandeec

##### New member
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

Can you upload the file so we can understand clearly

Here it is....In that sheet "What_I_need" shows what I want, in sheet "con"....

#### Attachments

• stafprofile.xlsx
17.3 KB · Views: 11
In cell B13 you can you use this formula and get what you want (the same for Height, Weight, BMI) :
=IF(ISTEXT(A12),"","Sex")

hope that helps

In cell B13 you can you use this formula and get what you want (the same for Height, Weight, BMI) :=IF(ISTEXT(A12),"","Sex")hope that helps
Sorry it doesn't work ....

Ok, take this one, it should work (put it in B3) :
=IF(LEN(A2)<1,"","Sex")

(Explanation: if the length of the word in A2 is less than 1 (i.e. blank) then leave it blank, else put Sex)

Last edited:
Ok, take this one, it should work (put it in B3) :
=IF(LEN(A2)<1,"","Sex")

(Explanation: if the length of the word in A2 is less than 1 (i.e. blank) then leave it blank, else put Sex)

It is really good ya.... I didn't think, abouth this point... Thank you so much