Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
How do I capture info from multiple sheets to main worksheet? | Excel Discussion (Misc queries) | |||
Macro to capture worksheet names | Excel Worksheet Functions | |||
Formula to capture historical data from data that changes daily | Excel Discussion (Misc queries) | |||
Formula to capture historical data from data that changes daily | Excel Worksheet Functions |