Excel VBA Macro - Find Word and Select that Column to Column D and copy

Hello,

I've looked around the forums and on Google and either I can't find the answer, or I don't understand what I found as the answer. I have several different macros that will find data throughout my workbook, compile this data into a single column, copy the column into Column C of a worksheet, and insert a new column C (moving the data over to a new column with each new column entered. The order of the columns is important but the data within the columns isn't, as long as it remains in the columns.

Problem: I create so many different columns with new data that the computer begins to work slowly when adding new columns so I need to copy these created columns (Column D through the current last column) only and put them in a whole new excel workbook.

Method: I have created an empty column with the word "End" in row 1 (colored red) that moves anywhere between Columns D until the last column where my computer starts to run slow (I estimate this to be around column ZZ but it could be further than that). I have also recorded and edited a macro that will search for the word "End" and select that column.

Please Login or Register  to view this content.

I need this code to continue to select (activate) all columns beginning at this End Column and returning to Column D and copy it. If it helps anything, my last row of any data is 101. Also, I'm just learning Excel VBA. I have no prior experience and am teaching myself through literature found on Google and You Tube videos. If you see anything with my coding as is (why are you selecting cells, etc.) please go easy. It's a combination of the recording and copied macro elements I've found around the internet, and I haven't learned how everything works enough in order to clean it up. I'm still trying to figure out how to work with VBA and I appreciate the work that everybody here has put into helping people like me learn.

BTW, do you have any recommendations of a site (or book) that has a list of the commands that VBA can do?

Thanks in advance,
- MsBBS

Hi,

I find it difficult to visualise this so it would be useful if you could upload the workbook.
It would also be useful if you could state the task you are wanting to achieve after processing the data andm manually add the set of results you expect after processing. Don't tell us how you are currently trying to do this, just tell us the start situation and show the end position. It may be that your task can be achieved in a more efficient manner.