I have a report that I am trying to build to show which assets belong to
which project. I thought about using a List Box so that the end user can
just click on a project and the data outside the List Box will populate to
show which assets belong to that project. My question is, because multiple
assets can belong to one project, is there a way to get the project to appear
only once in the List Box?

Thanks.

Visit John Walkenbach's site:
http://j-walk.com/ss/excel/tips/tip47.htm

Nick wrote:

I have a report that I am trying to build to show which assets belong to
which project. I thought about using a List Box so that the end user can
just click on a project and the data outside the List Box will populate to
show which assets belong to that project. My question is, because multiple
assets can belong to one project, is there a way to get the project to appear
only once in the List Box?

Thanks.

--

Dave Peterson