ExcelBanter - If Cell Contains Partial Text String Copy Entire Row to Another Spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If Cell Contains Partial Text String Copy Entire Row to Another Spreadsheet (https://www.excelbanter.com/excel-programming/445990-if-cell-contains-partial-text-string-copy-entire-row-another-spreadsheet.html)

biggaman76

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

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".

Claus Busch

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

All times are GMT +1. The time now is 03:26 AM.