"Jumbo's Chippy" wrote in message
...
I am designing a spreadsheet that will be used to monitor incidents
involving youngsters and when contact has been made with their parents /
guardians in relation to incidents. I am having difficulty in organising my
info though, as I don't want the user to scroll along across the
spreadsheet and so want the info to appear on screen without having to
scroll. Having said that, there is loads of info and so, I am wondering the
best way to go about it. I will need the following details:-

- Surname
- Foreame
- Date of Birth
- Telephone
- Address
- Telephone
- School
- Incident date
- Incident location
- Incident details
- Was contact made with regards to incident? (for this, a dropdown menu
listing "telephone, letter, visit"

Likewise, I want the spreadsheet to autoformat should the same Surname AND
Forename appear twice in the list.

Any suggestions? I played about with the idea of using comments in the
cells, however as it will be used by multiusers, would possibly need to
make the spreadsheet more user-friendly.

Now, having played about with the above, there is just far too many
columns to fit on screen at any one time.



You are about to use the wrong software for this project. I love Excel, but
a database like Access is really the way to go. Shall I elaborate on the
reasons?