recherche VBA

[bouahid]

hello i need you're help in macro Vba

1) put a reference in A1 in the sheet exemple.
2) select in references, all the lines having a "1" under the reference given in step 1) and put the related info in the sheet exemple where the VIA number of referencesrecherche VBA (6).xlsmrecherche VBA (6).xlsm matches the via number in exemple

[EirikDaude]

Does this do more or less what you want?Copy of recherche VBA (6).xlsm

[bouahid]

hello friend
yes it well but I want to respect the classification namber of "vai"
you find this joint "new format" the aplication of this macro but it lacks the filter with "1"
thank you to adapt this macro depending on your aplication new format.xlsm