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