Forum Discussion
Marc Wheeler
Jul 24, 2018Copper Contributor
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 ...
Marc Wheeler
Jul 30, 2018Copper Contributor
Thank you so much Lorenzo! It works perfectly.
Excellent job sir.
Lorenzo Kim
Aug 01, 2018Bronze Contributor
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..