helloakshay82
New member
- Joined
- May 31, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I have a file where sheet 3 has weekly targets. and sheet 4 has targets+actuals day wise.
All i want to do is copy targets day wise in to sheet 4
the user presses the button on sheet4 and gives a input of a queue name, it finds the q name first in sheet 3 and then should update the dates and rph and quality targets day wise in sheet 4.(example 0.33 rph for week 1, in sheet 4 it should update 0.33 for the 5 working days, and 0.44 for the next 5 working days for a particular queue
please note Few lines of where msg box is written is only to check the progress of the code this might be irrevalant when you are going through the code so please ignore them.
Any other info please let me know
All i want to do is copy targets day wise in to sheet 4
the user presses the button on sheet4 and gives a input of a queue name, it finds the q name first in sheet 3 and then should update the dates and rph and quality targets day wise in sheet 4.(example 0.33 rph for week 1, in sheet 4 it should update 0.33 for the 5 working days, and 0.44 for the next 5 working days for a particular queue
please note Few lines of where msg box is written is only to check the progress of the code this might be irrevalant when you are going through the code so please ignore them.
Any other info please let me know