Dear Friends,
Can anyone help me out from this problem? First of all I must pay my regards to all members of Ozgrid family for their co-operation extended to me so far. Now I am suck in a problem where I need help to resolve the issue.
Problem :
1. I have a Work book to maintain leave record of persons of a company. From Sheet No 3 to 13, I store the leave data in Columns B to Col. AA. Column A is for Sl no. I have 11 types of groups of persons and from a user form, I store the data group wise in these Sheets 3 to 13. Now I want to store the data month wise i.e. I want to use 12 more sheets for 12 months to store the data in same pattern month wise. This requires to filter data month wise from the 12 group wise sheets (Sheet 3 to 13) and paste them in 12 sheets designated for months(Jan, Feb……up to Dec). This should happen when I click a Command button on the user form say “Update Monthly data”. While updating monthly sheets, the group wise monthly data from the 13 sheets should get appended sheet wise i.e. first sheet 3 then sheet 4 and so on up to sheet 13 in the respective month sheets( Jan…Feb……Dec)
2. It may be note that at the beginning of the year i.e. January, leave data will be generally available for approximately next 4 months i.e. may be up to April or so as people are allowed to plan and apply for leave on dates within next 4 months and it gradually covers the other months as days goes on. Hence while transferring data to month wise sheets; NIL data may be available for the rear months.
I am attaching a sample sheet for better understanding.
Thanking you all in advance.
Request an early reply.
Regards,
Nm766
Filtering monthwise from multiple Data sheets and pasting in respective month sheets
-
-
-
Re: Filtering monthwise from multiple Data sheets and pasting in respective month sh
CommandButton on the UserForm?
I couldn't find a userform in the file attached.
-
Re: Filtering monthwise from multiple Data sheets and pasting in respective month sh
Dear Jindon,
Thanks for looking in to my problem. In recent past your help has extremely assisted in resolving some issues which were beyond my level. I would once again thank you for your valuable support. For this problem, I have reattached the sample sheet. I have worked out the feeding of data on the user form and getting them stored Category wise. Also To edit them by bringing back the recorded data on to another user form as edit form. But getting them transferred to month wise sheets has become the problem. requirement is leave for the month of January in each Category sheets ( Total 11 Sheets), the same rows should come to Sheet Leave_January and so on for other months as well. Hope you have under stood the problem. Once again thanks for your help so far and awaiting for a solution.
Regards,
nm766 -
Re: Filtering monthwise from multiple Data sheets and pasting in respective month sh
I can see an UserForm now, but no code ?
I have no idea how you want to use it.
-
Re: Filtering monthwise from multiple Data sheets and pasting in respective month sh
Dear Jindon,
I am very much sorry that I am unable to attach the modified sample as it is becoming more than 205 KB. I am trying to get it reduced. Or if you say, I can send it to your E-Mail. If so please, give me your e-mail Address so that I can send the data directly to you. -
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!