Copy columns adjacent to non blank column then stop automatically

[markDuffy]

Hi Guys
I have been copying a set of columns to adjacent to and existing entered column by manually entering a load more than I need and then deleting the surplus. What I would like to do is to copy the columns only until there are no more filled in columns. Difficult to explain so I have uploaded a small spread sheet showing what I am attempting to do. It may need step 7 but I don't know how to put it all together.

Please Login or Register  to view this content.

I have up to 100 or more of these down to half a dozen.
High Price (3) shows the filled in columns.

I hope this is clear.

Thanks again in advance
Mark

[ashishmehra2010]

Hi Mark,

Please mention your Data sheet from which code should copy the data to Destination Sheet (plz mention).

Regards,
AM

[markDuffy]

Hi Ashishmehra
I have renamed the sheets to what I have and What I want. I am hoping to find a more efficient means to copy the actions of the columns C:I to K because there is data in J and so on till there are no longer any entered columns.

Hope this is clear
Mark
Hope all is good in India. Spring here and the flowers are out.