Repeating names without dragging cells data/formula cells?

[srija]

I have to repeat this process for many names like following output. Is there any way to do automatically by click one #button(VBA or any) without dragging option.

Ex: if we enter names in any data form or in certain cells then it should get repeat itself(automatically) based on already filled A column values.

A column B column

E0H11 vamsi

E0H24 suresh

E0H01 mahesh

E0H54 (Repeat here)

EOH12 (Repeat here)


Output should be like:

A column B column

E0H11 vamsi

E0H24 suresh

E0H01 mahesh

E0H54 vamsi

EOH12 suresh

Appreciate your help

 

[sandy666]

duplicated

how to repeat column B names. Is there any another way rather than dragging the cells?

Please help me that how can we repeat column B names (vamsi and suresh) until cell value = EOH12 (column A). A column I B column E0H11 vamsi E0H24 suresh E0H01 (Repeat here) E0H54 (Repeat here) EOH12 (Repeat...

www.mrexcel.com

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).