hi.
i've one excel file with a lot of sheet and data on them. they are structured like that:
i've list box with list of items there ( sectors) and checkbox with amount. i want to choose sector name from list box and amount from checkbox. how can i define so that,when this Sector and this checkbox selected show on B2:L2 row information from "S1" sheet's B4:L4?
Something like this:
If listbox item index 2 selected and checkbox 6 checked , then show info from row B4:L4 in row B2:L2 .