looping columns with data

[bks35]

I'm a newbie to vba and I'm trying to write a macro where I select all the columns from column E on that have data and copy them into another workbook. So far I've got column E to copy and paste but I want to make a loop to check how many columns have data so that I'm not hardcoding the columns in. I think I need a Do While loop and to use offset but I'm not sure how to start this. Any help would be appreciated!!

 

[John Davis]

I'm a newbie to vba and I'm trying to write a macro where I select all the columns from column E on that have data and copy them into another workbook. So far I've got column E to copy and paste but I want to make a loop to check how many columns have data so that I'm not hardcoding the columns in. I think I need a Do While loop and to use offset but I'm not sure how to start this. Any help would be appreciated!!

A good idea would be to post the code that you already have. Then I'm sure alot of members on the board would be eager to help you.