I need a macro that will look in Column A for Section and copy the Contains in Column B in to Column D filling it down til it finding the next instance of Section until it gets to the last used row in Column A
Sample.xlsx
I need a macro that will look in Column A for Section and copy the Contains in Column B in to Column D filling it down til it finding the next instance of Section until it gets to the last used row in Column A
Sample.xlsx
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Close to what I need but I need it to key in on any time Section is in Column A
Your macro is using the first instance of "Section" and running it all the way to the bottom of the used range. In the spreadsheet there is many different time where it has the word "Section" and that is where I need it to change to whatever is column B and fill that down til it gets to the next and so on untill it get to the very end of the used range
was wondering if this is possible... I still need a macro that is able to look for the word Section in Column A then copy/fill down the info that is in Column B into Column D until it gets to the next instance of the word Section then start the process again and do this for the entire used range in Column A
I finally figured out a way to to get your code to do what I needed! The issue I was having is that with the scanned in document sometimes it wouldn't put a blank area in column "C" I had to create/call a macro before hand that inserted a blank row above every instance of "Section" then remove it once completed with your macro.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks