Need an help of vba code to split data from col F:F depends upon list of short keys values

Dear experts


i need a vba code help to split col values depends upon criteria key value then select only matching values move to another sheet
pls refer the short keys list out in J column

splited data has to move on sheet Brick_Data. if data already need to clear old data then paste

please find the attachment

thanks

Try this one

Please Login or Register  to view this content.

Hi brother thanks for code it works perfectly, i need small changes with formula you done!! replace with vlookup formula "=VLOOKUP(RC[-2],vlookupdata!C[-5]:C[-4],2,0)" in F column then paste only result data to Brick_Data avoid N/A's

i should open new thread but your code its look like easy for me to changes when ever i want if you teach me once time

Hello. In the attached variant:

- First, VLOOKUP is applied to column F.
- And then the information is distributed between the sheets 'Brick_Data' and 'The rest'.
- The 'Master' and 'vlookupdata' sheets are not modified in order to be able to do a "cross control".

PHP Code: 

For i = 2 To Q
  If Not IsError(a(i, 6)) Then
    T = 0
    For j = 1 To UBound(kv): T = T + InStr(a(i, 6), kv(j, 1)): Next
    If T > 0 Then
      R(1) = 1 + R(1): b(1)(R(1), 1) = i
    Else
      R(2) = 1 + R(2): b(2)(R(2), 1) = i
    End If
  End If
Next
ws = Array("Brick_Data", "The rest"): ReDim Preserve ws(1 To 2)
For j = 1 To 2
  With Sheets(ws(j))
    .[a1].CurrentRegion.Offset(1).Delete xlShiftUp
    .Range("A2:F2").Resize(R(j)) = Application.Index(a, b(j), Array(1, 2, 3, 4, 5, 6))
    .Range("A1").CurrentRegion.Columns.AutoFit
  End With
Next 


Hi brother @sintek the vlookup u added its copy entire data set into sheet Brick_Data , its should be `158 data but its copy 174 data's
thanks

Just one question: did you get to read message #5?...

Also post 2…

Originally Posted by beyond Excel

Just one question: did you get to read message #5?...

Originally Posted by JEC.

Also post 2…

I'm not sure if MicroTees realized that it's been 3 people trying to help him.

hi experts sorry for late reply i logged out couple of days it~solved Thanks for all