hi
for a basic excel user, i would recoment that you use microsoft querry(MSQ).
read up on MSQ.
in 2003 it is... dataimport external dataimport datafollow the wizard.

post back if you have problems.

regards
FSt1

"Teresa NS" wrote:

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