I am a basic Excel user. I have been given an assignment to create a
spreadsheet that pulls information directly from the Access database. Is it
possible for me to go into a Access query that contains the fields of Name,
area, year, term, manager and populate a spreadsheet that should be divided
by year, area, manager, term name to look like the following:

2008
Operations Smith Spring Mike Jones
Summer Fred Flintstone
Fall Kathy Smith
2007
R & D Rogers Spring Mary Lamb
Summer Dough Knoll
Fall Humpty Dumpty
I need the spreadsheet to pick out by criteria to fill in one cell at a
time. For example (Year = 2008) (Area = Operations), (Term = Spring), =name

I need to do this for current year and 4 years back. Is it possible to
search for each individual cell AND have the query refresh when the workbook
in Excel is opened?
--
Teresa
Norfolk Southern
Roanoke VA