Hi all,
I am a total beginner when it comes to VBA and i was wondering if it is possible to do the below with a macro? I want to be able to move any rows where the first cell of that row that contains a certain piece of text gets moved into a new workbook.
For example any row where the first cell contains the word "Excel" gets moved into a new workbook. I can then alter the macro for any other word that I need to look for.
The most I have atm is the ability to move the active row (but only a single row) to a new line, that is unfortunately the limit of my VBA knowledge.
I apologize as I know this is a terrible explanation but hopefully you guys get the idea
Bookmarks