Hi John,

Thank you for your patience; may be I have not explained clearly.

You are right, the whole idea of having a list box is to make multiple selections and only the selections are to go to the listbox.xls file.

To simplify, we can have three worksheets in listbox.xls, ?Floor Report?, ?Roof Report? & ?Wall Report?. The data based on the type can be exported to one of these sheets.


Thanks
Prakash