How to loop correctly

[Solomon14all]

Hi Everyone

i have to do the below repeated work
copy column a:b in main sheet, create new sheet (sheet1) paste in A:B, heading in b1 should be pasted in c1 to end of the date
delete column b:B

repeat the same till there is no column B in main sheet

i have done the work but dont know how to loop to repeat the action. needed to repeat this because coulmns in main sheet can increase or decrease.

Please Login or Register  to view this content.

[nankw83]

Try this code ...

Please Login or Register  to view this content.