I´m lacking knowledge about data gathering från Excel when using pull-down menues in spreadsheet. I have a form supposted to be sent out to a number of employees concerning their need of different office-features. They will monitor their work-day hour by hour for 4 weeks and choose type of work and focus-level. In the daily sheet I have two sets of roll-down- menus ("type of activity" and " prefered locatione"). One tab for every week and in the last tab I´d like my data som sum up. How do I gather/collect the data from the pull-down-lists i a correct way ti get a clear picture of their collective needs per week and per period in total?
