Excel Help

[dsb]

I’m trying to create a spread sheet and i want to be able to click a cell and it gives me certain options what to input in that cell click the option and it appears in the cell.

I’ve tried create list cell but that does not give me the drop down option when i click the cell that I want it in.

Hope that makes sense.

 

[dsb]

Linkex, that worked a treat, any idea how i now make them add up to give me a total of each test?

I have the table like this:

Test 1
Test 2
test 3
test 4

about 100 rows

So what i would like is it to add up who has done what test?

 

[dsb]

each column has a surname and a location there are over 100 columns and 6 locations I want it to auto count the locations once i have inputted it in.

so at the bottom I would have something like this showing totals.

Home 23
London 15


Its so I can just say how many people are in each location.

Hope this helps as I’m rubbish with excel but need it finished tomorrow.

Any help appreciated.

 

[dsb]

Ive sorted it only took me 6 hours to work it all out in the end.