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
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