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.

 

[Linkex]

Don't have excel on my home PC so I can't go into details - but if you google "Excel data validation", that should get you started.

 

[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?

 

[Sin_Chase]

Need to know more about your data structure/table to get an idea of what you are wanting to do.

By the sounds of it a Pivot Table should be able to do what you desire but unable to advise for sure without knowing exactly what it is you are trying to achieve.

 

[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.