apesgrapes
New Member
- Joined
- Jan 13, 2018
- Messages
- 1
I've found several macros and edited several that allow you to copy and paste to separate sheet if a cell contains certain content. However what I need is one that will search column A for a cell containing a string of text, then copy and paste rows containing that text, as well as the 11 rows preceding, to a different sheet.
My experience involves mostly recording macros and editing as needed, but I cannot figure out how to get it to copy additional rows in addition to the row containing the searched text.
Any help is appreciated!
My experience involves mostly recording macros and editing as needed, but I cannot figure out how to get it to copy additional rows in addition to the row containing the searched text.
Any help is appreciated!