Excel vba

Rahul Suryavanshi - May 27, 2016 at 06:55 AM

I want solution for one problem in excel VBA.

I have 2 columns A, B in excel. In column A, I have name POKHA written in all cells from A1 .............till infinite. Now I have list of names. Rakesh, Suresh, Naresh. I want to rotate the loop again and again like B1: Rakesh, B2: suresh, B3: Naresh, B4: Rakesh, B5:Suresh B6:Naresh and so on in B column which is exactly in front of A.

Please assist me in rotating the loop again and again.
3 names should come again and again in front of word POKHA in column A(infinite).