Thread: If Cell Contains Partial Text String Copy Entire Row to Another Spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default If Cell Contains Partial Text String Copy Entire Row to Another Spreadsheet
Hi,

Am Mon, 7 May 2012 13:29:48 +0000 schrieb biggaman76:

I am looking to create a code to search Column B for all cells that
contain "BP MH" and if it true copy entire row and paste to an existing
spreadsheet named "BpMH".

filter column B for "BP MH" and copy the visible rows to sheet BpMH


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote