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 pls find a revised sample for you to test.
I incorporated in it the SUB to delete duplicates in "NewSheet"
you can change the name of the sheet in the VBE.
in that routine you can continuously add records of E=Full to the newsheet -
just delete any duplicates afterwards.
Hope this helps..
Mr. Wheeler
so sorry, there is an error in the Delete_Duplicate module!
it only checks content of cell A not the entire range from A to P.
I'll try to fix it.
my apologies..