MAcro to copy specific data in other workbook, but name of the workbook will change

[etunam]

Hello, I am trying to biuld a macro to filter and copy data to some colums in other workbook, but I will do it for several workbooks:
The source workbook is located in the same folder than destination book (I made a lot of folders with all the workbooks) and source workbook has a long name containing the word "woll", the worksheet will be the same for all the source book (Woll Basic) ant the column the same V, begining from V2.


I made this macro to resolve the problem of the relative path:

Please Login or Register  to view this content.

The destination workbook will be always named Planti, and the worksheet "Wills"

What I am trying to do, without any good result, is filter column V to find any cell with "wild" or "explo" in the text and copy it to column A in Planti, together with the corresponding value of W and AA, that will be pasted in columns E and C.

I am begining with the macros but is too dificult for me...

If I have this I can try to do the next step, sort the data in another columnwith the value of column AA (paste in C)

Thanks a lot!!!

[Norie]

The code you have so far looks like a good start.

What exactly are you having problems with?

PS Can you edit your post to enclose the code in code tags rather then colouring it bright red?

[etunam]

Well I have problem with the part of filtering and copy to another workbook....