![]() |
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