LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count partial matched text string Chapi New Users to Excel 5 July 5th 10 06:34 AM
Copy entire row(s) to another workbook based on partial cell crite Nik Excel Programming 3 September 24th 09 07:04 PM
auto bold partial text in a string dave in Toronto Excel Discussion (Misc queries) 1 June 12th 07 01:07 PM
Import partial record from text file string goss[_37_] Excel Programming 1 November 16th 04 07:38 PM
Import partial record from text file string goss[_36_] Excel Programming 1 November 16th 04 03:45 AM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"