Searching Column for Part of a Term

**Erenagh** · 06-21-2011, 04:07 PM

I am trying to search Column B for 0X and return all results in another sheet called reports. The problem is the term is a 10 or 11 characters long for example 1MT000000X but the only ones I need end with 0X and there are to many variables in the other 9 characters. In Psuedocode

If Column B Contains 0X then Copy Row to Sheet Reports

**realniceguy5000** · 06-21-2011, 04:17 PM

Can you post a workbook with your data layout.

:-)

**snb** · 06-21-2011, 04:23 PM

Please Login or Register  to view this content.

**Haseeb Avarakkan** · 06-21-2011, 05:05 PM

Hello Erenagh,

See the attached. On cell F1 just enter the last 1, 2, 3, ...11 characters to get the data. Hope this helps

**Erenagh** · 06-22-2011, 10:26 AM

Sorry all I am trying to get all this data to pull from my "Master" worksheet that then get pasting into my worksheet called "reports" so im trying to avoid formulas if I can and autofilter. It worked great though. Thank you for your responses so far!

**realniceguy5000** · 06-22-2011, 11:17 AM

Here is another method? No Auto Filter and No Formula's

Please Login or Register  to view this content.

**snb** · 06-22-2011, 11:32 AM

so im trying to avoid formulas if I can and autofilter

Why not avoiding Excel at all ?

**Erenagh** · 06-22-2011, 12:55 PM

The reason I am trying to avoid both of those is because using a formula in my sheet is impratical because it is changed all the time and there are already 57 columns.

Im trying to avoid autofilter because I have to use autofilter in the master spread sheet or copy the entire contents and then autofilter into my reports page. Both of which seem to lag greatly when the master worksheet is shared with the team.

I know I don't know much about VBA but I am learning as I go hence the questions. Also, I am trying to develop products that don't just work functionally but also expeditiously when running my reports. Strangely enough when a excel document is shared it increases the time to run a report almost ten fold. From what I read though this is due to a comparison made to each accompanied cell to verify changes... anywho, that is why I dont wish to avoid excel just certain factors of it.