Need to create a custom macro

June 18, 2013 at 08:28:32
Specs: Windows 7
Hey guys,

I'm fairly green to macros but am trying to learn. What i'm trying to do is create a macro that will go down through a specific column and search for the text "Client Total:". My hope would be that every time it sees that specific text it would do two things (1) insert a new row directly above the line where the text is identified (2) skip the cell immediately to the right, but starting on the second cell to the right of the text I would like it to insert two new cells, shifting everything else to the right.

There has to be a way to do this, probably pretty easily. I'm just not experienced enough to make it happen. Anyone feel like teaching me how?


See More: Need to create a custom macro

Report •

June 18, 2013 at 09:04:32
Depending on how green you are, you might be able to modify the code shown here, which insets a new row when 2 vertically consecutive cells don't match. Modifying code to make it work for you is a great way to learn VBA.:

Another great way to learn VBA is to record what you want done and then modify the recorded code to fit your specific needs.

The following tutorial can be very helpful by showing you some techniques that will allow you follow along as the code is running so that you can see what it is doing as a means to both understand recorded code and code copied from forums such as

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question