fix code search by dropdown and get data from sheet to another

  • hi

    i need solve this code doesn't work no showing any data in sheet(account) from sheet(data) in sheet account i have to choose client in b1 by dropdown and write from date in b2 and b3 to date then run macro show the data in sheet (aacount)

    this is my code

  • thanks Royuk but it shows all data as you see in b1 choose the name and from date to date so it supposses getting a data related name and date not get all of data

  • Try changing the field in this line

    Code
    Sheets("DATA").Range("A3:g" & LastR1).AutoFilter Field:=7, Criteria1:=SText

    equal to 6.

    If I've been helpful, let me know. If I haven't, let me know that too. 

  • thanks dangelor yes this is what i'm looking for but i have last request i would when dropdown is empty so it shows all of data

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!