Hi All


I have a workbook having a "COMPANY INFO" sheet, a "COMPANY DATA"
sheet and an "EMPLOYEE" sheet.

I would like to type a company number on the "COMPANY INFO" sheet and
have company info populate the upper portion of the sheet which would
come from the "COMPANY DATA" sheet. This part is easy.

I want the lower portion of the "COMPANY INFO" sheet to be populated
with all the names associated with that company which would comfrom
the "EMPLOYEE" sheet.

Lets say I allow 10 lines for names on the lower portion of the
"COMPANY INFO" sheet and we'll assume that there is 1 or more names,
but not to exceed 10 associated with any of the companies.

If for example, one of the companies has 8 employees, how can I show
each of the employees only once in the lower portion that I've
alloted? Keep in mind that the names may not be grouped in a line by
line fashion on the "EMPLOYEE" sheet. they, more than likely, wil be
scattered throughout the "EMPLOYEE" sheet.

I know this is more suited to a data base but I'd like to ues it in
Excel.

Thanks in advance for any help you can give me.