Is it possible to populate an array of data from using dropdown list value in Excel? -

here problem:

i have worksheet dedicated raw data-set in columns a:c. data-set consists of amounts, dates (mm/yyyy), , status.

within same worksheet have dedicated arrays count specific amounts each month of year , sort out status' raw data set. in total, have 24 arrays dedicated displaying 2 years of data.

using name manager i've named arrays corresponding month.

what i'd populate 1 array @ time when called upon list drop-down value (the mm/yyyy) on different worksheet. possible?

i've experimented vlookup , hlookup no luck. appreciated.

you can try advanced filter. sub adv_filter() range("a1:c56").advancedfilter action:=xlfilterinplace, criteriarange:= _ range("f1:f2"), unique:=false end sub

here f1:f2 dates drop down. sample adv filter have take complete data set sheet. can try recording macro.

happy help. tell me if further assistance required.