View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gina[_2_] Gina[_2_] is offline
external usenet poster
 
Posts: 49
Default unsure how to set up worksheet to capture data

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