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 ...
Lorenzo Kim
Jul 28, 2018Bronze Contributor
Mr. Wheeler
Based on what I understand from your query, I made a sample where you can try.
always make backup copies of your works.
It is not the best structured code but it delivers !
hopefully this is what you needed.
otherwise, there are many good people here in the forum that can help you.. as they did me.