A table within a cell?
 

Hi,

I'm creating a list of assemblies. I want to be able to
list all the parts in one cell if possible and to still be
able to use them with the filter.

At the top of the sheet i have frozen the column titles
and added an auto filter so the user is able to search
each column.

Clear as mud?

I'm sure just entering 'A0123 A0234' would do the job but
it seems a bit...well, lame. Any better ideas remembering
i dont want to use more than 1 cell?

To give you some idea there are 160+ assemblies and each
has about 5 parts.

cheers

A table within a cell?
 

Hi
AFAIK not possible if you still want to use the filter

--
Regards
Frank Kabel
Frankfurt, Germany


ADRIAN wrote:
Hi,

I'm creating a list of assemblies. I want to be able to
list all the parts in one cell if possible and to still be
able to use them with the filter.

At the top of the sheet i have frozen the column titles
and added an auto filter so the user is able to search
each column.

Clear as mud?

I'm sure just entering 'A0123 A0234' would do the job but
it seems a bit...well, lame. Any better ideas remembering
i dont want to use more than 1 cell?

To give you some idea there are 160+ assemblies and each
has about 5 parts.

cheers