Hi @vletm ,
Thanks for commenting. Can you do one favour, can u put the codes here where u have designed the enable of login once id is inputted and disabling after it is clicked once from your pri version
Hi All,
I have recently gone through some post in this forum to help me in creating a time register. Attached is the macro file that i found which was already prepared and it works excellent, however i would require some changes in this file to modify to my requirements.
AMS sheet --> This is...
Well seriously after telling all my requirements u are still telling u are guessing??.
Wat u didn't understand from my requirements is wat I am asking but still u are telling the same answer!!!
Wat guess? Really can't understand ur questions..
Is there anything still not clear? Else please give a macro for Allocation alone I will try to modify..
See I agree I use the term urgent but u are still pin pointing in that..
I gave all requirements and details. The allocation should happen evenly and in ascending order that's why we have case entry date and time..
Please let me know if u require any other details...
'Terms'
1. Each user should get a individual spreadsheet of his/her cases - hmm? The individual spreadsheet can be saved in a specific folder in a share drive
2. I have a specific column named "rate" ... where? If u look at the data sheet in my Excel u will see a column which has "card" and "...
FIFO is first in first out. Alloxation should happen basis on the entry date and time. (In ascending order).
I will copy the data every 1 hour and if there are cases already allocated should be shown as duplicates and those cases should not be allocated again...
Hi Thanks for the reply.
Please find the attached sample format.
1. When I click assign button, it should allocate all cases except the one that has card in the row.
2. When I click card split the rows that has column should be moved to a separate sheet in the same work book
3. Atlast when I...
Guys I just joined this forum and gone through the posts. It s really amazing and useful for all excel learner's.
I need now a macro for allocation of cases to the team.
1. Each user should get a individual spreadsheet of his/her cases
2. I have a specific column named "rate" which should not...
Guys I just joined this forum and gone through the posts. It s really amazing and useful for all excel learner's.
I need now a macro for allocation of cases to the team.
1. Each user should get a individual spreadsheet of his/her cases
2. I have a specific column named "rate" which should not...