Hey all,
I am looking for a macro that will search an entire sheet for the letters "EDS" - however there will be things before and after it so it will need wildcards on both ends - If it finds EDS in a cell then I need the entire row to be cut and pasted into Sheet 2. And so on, there will be several rows with EDS so I need them to all end up on sheet 2.
Thanks for the help - I appreciate it
Last edited by TShelt; 06-04-2012 at 10:18 AM.
Is there a specific column that the EDS in located or is it scattered throughout the workbook?
Thanks!
It will be in Column A
Do you have a sample file that you can upload?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Why not filter col A on all cells containing your string and cut/paste them to another sheet ?
File is attached, - in this example Row 1 2 3 and 6 would be moved to sheet 2 and row 4 and 5 would stay in sheet 1
There are many ways of doing this like autofilter, looping, etc.
Try this code
Please Login or Register to view this content.
Perfect, I can tweak from there - thanks again for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks