Organising Info
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. |
All times are GMT +1. The time now is 07:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com