autofilter values
Hi
after an autofilter, (Selection.AutoFilter field:= 3, Criteria1:="=X") I will retrieve all "X" under the 1cEcto (sheet looks like below !!) (A) (B) (c) 1) B1=SUBTOTAL(3;A:A) 2)AHC Batch 1cEcto 3)001 05 4)002 06 X 5)003 01 6)004 01 X How could I find all (A) related nb_bout_IDBS_trouvées = Worksheets("IDBS").Range("B1").Value For recherche_bout = 1 To nb_bout_IDBS_trouvées AHC_IDBS = Worksheets("IDBS").Cells(recherche_bout + 1, 1).Value === this last line does not work because I will retrie AHC_IDBS = 001 and need to be 002 // next one will be 004 |
All times are GMT +1. The time now is 03:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com