S
Shane
Is it possible, in Excel 2004, to produce a list such that the entries
within that list contain lists for some fields?
An example of the format which I wish to create would be a list of the
customers of a computer repair shop with a small history of the
dealings with each customer, as in the diagram below, which hopefully
is clear, though I realise that it is subject to the whims of
formatting.
ID Name Address History
1 Tom Fictional Lane 3/4 - brought in
4/4 - repaired
5/4 - picked up
2 Dick Imaginary Road 4/4 - brought in
5/4 - replacement ordered
3 Harry Mythical Avenue 5/4 - brought in
Though I could make a list of customers that was not managed by the
List Manager and create a List Manager-managed list for the histories,
I would lose many of the advantages of being able to use List Manager
to manipulate the list.
Because my concern is to be able to create a functioning list as
described, if one cannot create lists within lists, any imaginative
solutions to my problem are welcome.
within that list contain lists for some fields?
An example of the format which I wish to create would be a list of the
customers of a computer repair shop with a small history of the
dealings with each customer, as in the diagram below, which hopefully
is clear, though I realise that it is subject to the whims of
formatting.
ID Name Address History
1 Tom Fictional Lane 3/4 - brought in
4/4 - repaired
5/4 - picked up
2 Dick Imaginary Road 4/4 - brought in
5/4 - replacement ordered
3 Harry Mythical Avenue 5/4 - brought in
Though I could make a list of customers that was not managed by the
List Manager and create a List Manager-managed list for the histories,
I would lose many of the advantages of being able to use List Manager
to manipulate the list.
Because my concern is to be able to create a functioning list as
described, if one cannot create lists within lists, any imaginative
solutions to my problem are welcome.