Forum Discussion
VBA script - find a particular word - copy whole row to new sheet
Hi, I need a VBA script that automatically searches for the word 'full' in column 'E' (from A to P) and then copies the entire row onto a new sheet. I want this to be a continuous process that I ...
Mr. Wheeler just in case you don't know how to use my test workbook... at the Top ribbon click DEVELOPER then the "Macro" at the left corner - Run the macros. or press ALT F8 and Run the macros... Sheet1 contains just a representation of a worksheet per your info where column E is where you find "Full" .. in case something 'went wrong' - just exit WITHOUT SAVING... HTH
Thank you so much Lorenzo! It works perfectly.
Excellent job sir.
Mr. Wheeler,
I was looking at the codes recently and I discovered a glitch.
There was an error in the Third turn copying - the attached file now is corrected and I made it a little bit more presentable.
Based on the macros - you can copy anytime you wish then just delete all duplicates.
Thank you..
Mr. Wheeler
Thank you for your feedback and I am glad that I could help.
Attached is a final copy of the test sample, I added a module for sorting an opened sheet
courtesy of Mr. Man Fai Chan - a very kind and helping man.
Remember, there are many other good men in this forum who are very willing to help.
I always seek help in this forum whenever needed.
GOOD HUNTING..
