Using External Files

[BennyK87]

Ok so what im doing is trying to create a database type thing in excel 2007
that allows you to enter golf course details and lets you enter your score
for each round you play and this data will then produce a number of different
reports. Ive made a screen for the user to enter the course details with its
name, par of each hole, distance etc etc. I then want this to link with the
round details part so that the user is able to select from a drop down list
the course that he/she played and it will come up with all details for that
course. I remember doing something like this at school but that was a long
time ago and i was wondering what the best method was to do it. I seem to
remember using external text files in notepad!!??

Any help would be appreciated

 

[ShaneDevenshire]

Hi,

I'm not 100% sure what you want to happen, but you might look at the Auto
Filter command under Data, Filter and see if that gives you any ideas.

Alternatively, you could create a bunch of VLOOKUP(key,Table,Column,Type)
formulas which reference a cell with a Data, Validation, List option set up
with the name of all the courses.
For example, if Par was stored in column C of your table and column A
contained the names of the courses then the formula to bring back the Par
would be
=VLOOKUP(C1,Sheet2!A1:H100,3,False) where C1 has the data validation list
and displays the Course name that matches the name in the first column of the
range A1:H100 on Sheet2. 3 is the column containing the Par and false means
you want and exact match.


If this helps, please click the Yes button.

 

[BennyK87]

Ahh yea, VLOOKUP. I remember. I know, sorry its hard to explain. That does
help with getting the data back but what ive got is a form for the user to
fill out about the golf course, how do i store the details that they enter,
such as the name, par etc and then clear the form so that it is blank again
but has saved the information the user entered?

Thanks