Stressing! Does anyone know how to incorporate a conditional filter into my existing code? I need it to start right after the highlighting is complete... (existing code below)
Here's an uploaded small example of the file: https://app.box.com/s/ug4fblqau6lq9a91w6k7
Please Login or Register  to view this content.
I need the filter to:
1-Start on "BOM Worksheet" tab
2-Look to target cell: "J3" for main Part #
3-Jump to "TO" tab, COL B to look for MATCH
4-If match found, look to adjacent COL H for a special code

Now that the special code has been identified in COL H of "TO" tab, we need to:
1-- locate all rows THAT HAVE NOT BEEN COLORIZED GREEN and hold THAT CODE,
(and/or a row that)
2-- HAS NOT BEEN COLORIZED AND IS BLANK WITH NO CODE,
then proceed w/ my pre-existing code to begin copying data over to BOM sheet...

(Currently, it is copying over a ton of rows we don't need)
I just need it to look for something more specific before it copies over...

*Important Note regarding the COL H search for the code...(does NOT need to be an exact match)
If the code is a "D"
The cell data could look like this:
"D"
"ABCDEF"
"CDE"
"(blank cell that has not been colored green)

Therefore, if the "D" is found in any string within a cell in COL H then proceed with rest of code...

There should ALWAYS be a match, but if for some strange reason it could not find a match when looking for "J3"'s Part# on the TO sheet,
MsgBox "No Matches Found Using Your End Item Part #"