Excel database

A

allicore

I remember from high school being able to create a database in excel.
I need to create a database where i can easily type up an equipment
list when i send the photographer i work for out of town so they have
a list of the equipment they are bringing with them. but i don't want
to have to type out everything every time. I would like to be able to
type in the name of the kit and everything inside the kit
automatically falls underneath it on the list. Is there anyway to do
that in excel or word? HELP?!?!?!?!?
-Alli
 
B

Bob Greenblatt

I remember from high school being able to create a database in excel.
I need to create a database where i can easily type up an equipment
list when i send the photographer i work for out of town so they have
a list of the equipment they are bringing with them. but i don't want
to have to type out everything every time. I would like to be able to
type in the name of the kit and everything inside the kit
automatically falls underneath it on the list. Is there anyway to do
that in excel or word? HELP?!?!?!?!?
-Alli
Click to expand...
Excel has a list manager feature that may answer most of your needs. As far
as a database goes, virtually all functions are still supported. I'm not
sure what you are trying to do, but try filtering the list and selecting the
item you want. Maybe an advanced filter will be useful. Check the help files
on these features. Let us know with some more specifics about the trouble
you are having.
 
C

CyberTaz

Bob G. is on the trail as far as XL, but since you also asked about Word...

One option is to create the lists of kits & their content, select each list
one at a time & use Insert>AutoText>New to create AutoText Items. Give each
a unique name conssting f at least 4 characters (kit1, kit2, kit3). In any
Word doc you can then type the name & press return to insert a copy of the
list.

Find more detail in Word Help using the keyword AutoText.
 
Top