Lacostee12
New Member
- Joined
- Jun 15, 2011
- Messages
- 4
Hello,
I have a big problem. I should a do excel workbook where person can aswers his feeling in every week. There is 12 different persons who can aswer this and you have to choose who is aswering from a dropdown option. Then there should be 5 different options (maybe with optinobuttons) about emotions (Great,good,ok etc.) and one "Send" -button which should register this press to table in an another sheet.
In another sheet, there should be collective tables for every person for week about aswering and emonitional choise. I can make these tables and dropdown option.
Can anyone help me how i program to register aswers from another sheet to tables so it's depends about choise in dropdown option, week and emotional choise in option buttons? I'm not sure if excel can identify week automatically or should that been written also in first sheet?
I also need help to get reports/charts weekly, monthly and yearly from aswers. Reports should be able to get by person or all together.
Is that all possible? I'm amateur so i really need help. I can do something with Visual Basic but i need insrtuctions for these issues.
Thank you!!
I have a big problem. I should a do excel workbook where person can aswers his feeling in every week. There is 12 different persons who can aswer this and you have to choose who is aswering from a dropdown option. Then there should be 5 different options (maybe with optinobuttons) about emotions (Great,good,ok etc.) and one "Send" -button which should register this press to table in an another sheet.
In another sheet, there should be collective tables for every person for week about aswering and emonitional choise. I can make these tables and dropdown option.
Can anyone help me how i program to register aswers from another sheet to tables so it's depends about choise in dropdown option, week and emotional choise in option buttons? I'm not sure if excel can identify week automatically or should that been written also in first sheet?
I also need help to get reports/charts weekly, monthly and yearly from aswers. Reports should be able to get by person or all together.
Is that all possible? I'm amateur so i really need help. I can do something with Visual Basic but i need insrtuctions for these issues.
Thank you!!
