B
Bruce Baird
I want to automatically create a table in excel based upon
a "many-to-one" relationship.
I have a table of inventoried items:
Asset# Desc Type Function PurDate etc
The "type" cell (field) is what I want to use as the basis
of the many-to-one. In other words, if there are a number
of "types" with the designation of LP, for instance, then I
want to have excel create a table displaying just the LP
records in my inventory table.
Hope this makes sense. Can it be done inside of Excel or
do I have to go "external" using Access or whatever.
Many thanks,
Bruce
a "many-to-one" relationship.
I have a table of inventoried items:
Asset# Desc Type Function PurDate etc
The "type" cell (field) is what I want to use as the basis
of the many-to-one. In other words, if there are a number
of "types" with the designation of LP, for instance, then I
want to have excel create a table displaying just the LP
records in my inventory table.
Hope this makes sense. Can it be done inside of Excel or
do I have to go "external" using Access or whatever.
Many thanks,
Bruce