Stumped, multiple questions

[Jar888]

Hey, multiple questions incoming due to me being a complete novice at excel.

This might be a long shot, and I've resolved to probably using a mix of a formula's and macros.

We are currently tracking safety at an individual level in our company, and I'm spending 2 - 3 hours inputting data for 100's of people mostly due to nothing being alphabetized and setting up the spreadsheet for tracking each individual day.

What I envision;

1. Import roster from master sheet to track who was on site the day before
2. Alphabetize workers from particular rows who would be doing TTT and TTTC's
3. Insert 2 new additional columns labeled TTT and TTTC's
4. Manually input TTT and TTTC's for the past 24 hours
5. Somehow lock the above numbers in on the row relative to the name, as the roster will likely change on a weekly basis
^ Not sure weather having an input data sheet and building the individual days onto a weekly sheet would be better for this

Any help, or advise would be greatly appreciated! :D

 

[sijpie]

When setting up any database, the most important thing to do is think about the structure.
You have employees.
You have a roster with varying employees.
You want to record the safety indicators against each employee and date.

So what you need is a table with ALL employees and behind their names the dates and indicators. You don't want to build this record every day, you want to add to it.

The handiest for you will be an input form that looks up the workers on a particular day (mostly yesterday) from the roster. You can add the indicators behind each name on the form, and then the form will write the results to the correct date (and names) on the record sheet.

Does that sum up what you need?