supportforum
New Member
- Joined
- Oct 30, 2012
- Messages
- 1
Hi All,
File can be found at : www.indianwebcompany.com/common/vacation_planner_yearly.xlsb
I am very new to excel data but some how managed to found what i needed , it is a vacation planner. I did some modifications to the same but still require some more & that i am not able to do. The problem is :
1.) On first sheet "Full year view", we have an option where i can select a user from drop down and see his/her leave details marked in different colors.
2) Now what i wanted to have is one more option added to same select box on first sheet only with value "All", to which whenever selected all leaves will appear for all users with some predefined color for every user [not required leave type in this case or remove that completely in any case].
3) Also for overlapping leaves also it would be best if we could show some specific color.
I would really appreciate if anybody could help in submitting my project tomorrow!!
Thanks & Best Regards
Juliee
File can be found at : www.indianwebcompany.com/common/vacation_planner_yearly.xlsb
I am very new to excel data but some how managed to found what i needed , it is a vacation planner. I did some modifications to the same but still require some more & that i am not able to do. The problem is :
1.) On first sheet "Full year view", we have an option where i can select a user from drop down and see his/her leave details marked in different colors.
2) Now what i wanted to have is one more option added to same select box on first sheet only with value "All", to which whenever selected all leaves will appear for all users with some predefined color for every user [not required leave type in this case or remove that completely in any case].
3) Also for overlapping leaves also it would be best if we could show some specific color.
I would really appreciate if anybody could help in submitting my project tomorrow!!
Thanks & Best Regards
Juliee
