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
attached is a revised sample for you to test. It can now delete duplicate range A-P.
it may not be an MVP class work, but it delivers. If you find some errors - pls inform me.
** if ever I got hold of a better structured codes, I'll send it to you soonest.
This is my way of paying it forward for the things that I have learned from this forum through the kind assistance of the many nice people here.
Hope this helps