unsure how to set up worksheet to capture data

G

Gina

I am making a spreadsheet where I need to track:

Area, Task, Result (Example: Office, Vacuum, Yes)
And
Supervisor, Employee, Date Entered


and I'm unsure the best way to set up the worksheet. Right now it's:



Area Area 1
Area 2 Area 2
Vacuum Dust
Vacuum Windows
DateEntered, Supervisor, Employee1 yes yes no
yes
DateEntered, Supervisor, Employee2 yes yes no
yes

But I'm finding this difficult to chart. Is there a good way to do this in
Excel, or am I stuck using MS Access and doing lookups?

Thanks!
Gina
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top