Hi All,
I am making a form that contains a list box. I know how to specify the source but I want to do this:
I have two columns (A & B). A contains a list of invoice numbers and B contains the year of the invoice. Is it possible to select A as the source for the list box, but only use the cells that have 2009 in column B.
Thanks,
Damien
I am making a form that contains a list box. I know how to specify the source but I want to do this:
I have two columns (A & B). A contains a list of invoice numbers and B contains the year of the invoice. Is it possible to select A as the source for the list box, but only use the cells that have 2009 in column B.
Thanks,
Damien