i have 12 sheets in my excel i have taken sheet1(destination) in that i used to display particular user data(details) with headers
i have created an macro called searchcopy
what i was trying to it should display Month name(Which Month they have taken a leave
following this columns
TOTAL PRESENTS
TOTAL WEEKLY OFF
TOTAL LEAVES
TOTAL ABSENTS
TOTAL HALFDAY
TOTAL PRESENT
i have attached My ExcelSheet.....Please help me
Please Login or Register to view this content.
You may try this worksheet change event code to get the desired output.
Please find the attached sheet and just change either the Month or Employee to get the desired output in the yellow cells.Please Login or Register to view this content.
Is this what you are trying to achieve?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
tanks for u r knowledge its working
sorry for it
i wanted if i want to display in summary seet only selected mont list data
Last edited by baig123; 10-10-2014 at 01:04 AM. Reason: paragrap
i ave more tan 50 employee but in validation not taking more tan 15 values
I have created a list of Employees in col. AA and then created a dynamic drop down list referencing the list in col. AA. You can replace this list in Col. AA with your real employee names. If you add any name in this list in future, that name will be included in the drop down list of employees in H9 automatically.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks