Re: If Cell Contains Partial Text String Copy Entire Row to Another Spreadsheet

Claus Busch

Guest

Posts: n/a

7th May 2012

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

« Re: hide rows in workbook | VB If statement Help »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy entire row(s) to another workbook based on partial cell crite	Nik	Microsoft Excel Programming	3	24th Sep 2009 07:04 PM
pull data from one row if another row contains certain text	coasterdude	Microsoft Excel Discussion	6	23rd Jan 2009 11:41 PM
Deleting entire row if cell contains "value" - how to review everytime?	V	Microsoft Excel Worksheet Functions	0	16th Aug 2008 03:23 AM
Move entire row if it contains specified text.	JFREE223	Microsoft Excel Misc	13	5th Jun 2008 03:20 PM
Re: Converting a string to a string that contains the ASCII values of each letter in the origional string	Frank Oquendo	Microsoft C# .NET	0	31st Jul 2003 08:36 PM