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

B

biggaman76

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

Claus Busch

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".
Click to expand...

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


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create if partial match then copy and paste data from one cell to another 1
Copy entire row(s) to another workbook based on partial cell crite 3
Macro analyses Cell . If text found , delets entire row 6
VBA macro delete row - Help needed 7
Search column for date format; cut and paste multiple cells to row above 1
Copying row into new sheet if it contains certain text 8
Copy and paste from one tab to another with certain rules using VBA 3
How to do an IF statement that copy data based on a partial match 0

Top