ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   unsure how to set up worksheet to capture data (https://www.excelbanter.com/excel-discussion-misc-queries/197466-unsure-how-set-up-worksheet-capture-data.html)

Gina[_2_]

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




All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com