Filter by criteria

[rshnkmr39]

HI ,

I have 2 workbooks "Item" and "Detail"

The item tab has data i.e items in the 3rd row. for example
055-02 055-06 055-03 055-12 055-96 055-72 055-25 055-30 055-06 055-09 .......

The second workbook "detail" has top items in the 3rd row, for example
055-72 055-30

I want a VBA code to locate the exact column which contains "055-72" and apply filter in that column

in this case 055-72 is in column "f"

and then remove filter and locate the column containing 055-30 from the "Item" tab and apply filter..

Here the "Item" tab could have that item in any column.

Thank you so much in advance

[rshnkmr39]

Basically I need to search for a prticular item in a row(range) and apply filter to that particular column where the item matches

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[rshnkmr39]

Yes this works but I need to copy the filtered data once this is done

[JOHN H. DAVIS]

Where do you want to copy it too?

[rshnkmr39]

Hey John That worked ,I was able to copy the filtered range
Now I want to add a vlookup formula from the active cell to the next 2000 cells and i tried the below code
It doesnt work could y
Range(ActiveCell, ActiveCell.Cells(2000, 1)).Value = WorksheetFunction.VLookup(ActiveCell.Offset(0, -1), Worksheets("RBU Report").Range("$A$1:$A$2000"), 1, False)

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.