Just wondering if anyone can advise me on some help with putting a constraint on a list box.
I imported account numbers for all accounts in my Excel sheet. Once I did this I set a formula to get the sum of all costs under 20 euro and a formula to show all costs between 20 and 40.
This is fine when I click on an account within this range it does what I want.
The problem is their are some accounts that are over 40 but I don't want to look at these. So there are a lot of accounts that are over 40 and still in the list box.
What I want is to filter out all the accounts that are over 40 when grossed together under cost. If I could do this I could just have the accounts in up to 40 which I want So I could highlight these all in a table and get a sum figure as I can't do this with accounts in the list box that are over 40.
For Example I have two list boxes Account Number and Cost figures. Each account has several transactions so their will be several cost items in the cost box. So when they are under 40 that's fine.
What I am trying to do is remove accounts from the list box Account Number that are over 40 as a grossed cost.
