One more thing, You can also use shortcuts to enter time/date. *Ctrl+;* to enter date and *Ctrl+shift+;* to enter time.
On Mon, Apr 13, 2009 at 7:00 PM, Harmeet Singh <harmeet.hew...@gmail.com>wrote: > Hi Harish, > First of all, Thanks a lot for appreciation. > If now I do the changes that you have mentioned in your mail, will be a > spoon feeding. > I have not protected the code that I have sent you. It would be a good > learning for you if you try and do it by yourself. You just need to write > two lines similar to what I used. > > Let me know if you stuck anywhere. > Regards, > Harmeet singh. > On Sun, Apr 12, 2009 at 11:31 PM, Harish Sharma < > harishsharma...@gmail.com> wrote: > >> Thanks a lot Harmeet... >> Can u also get me one more functionality here that as soon as one agent >> acquires the job time and date he acquired also appears and untill he >> finishes the job by selecting as close which will be a drop down in next >> column to acquired time column. Once agent uses close from drop down in next >> column closing time & date should also appear. >> >> Thanks once again.... >> Harish >> >> 2009/4/11 Harmeet Singh <harmeet.hew...@gmail.com> >> >>> Bingo. >>> >>> See attached file. >>> >>> On Sat, Apr 11, 2009 at 4:35 PM, Harish Sharma < >>> harishsharma...@gmail.com> wrote: >>> >>>> Hi Ashish, >>>> >>>> Can you please help me with the file attached. >>>> >>>> I have raw data in first sheet columns "B,C&D" and I have 9 >>>> associates to work on this data further but I want now to build a macro >>>> where if any agent click on acquire button(will be available in respective >>>> agent's sheet) he gets the data (first availabel data in the raw)from raw >>>> data sheet in FIFO basis and all the agents will also be working on the >>>> sheet together so it would be shared. >>>> >>>> But the data should not be duplicating and raw data should be protected >>>> and once the data is acuired by any agent his name should appear in first >>>> column. >>>> >>>> Thanks in advance >>>> >>>> -- >>>> Kind Regards, >>>> Harish Sharma >>>> >>>> >>>> >>> >>> >>> -- >>> Thanks & Regards, >>> >>> Harmeet Singh >>> >>> >>> >> >> >> -- >> Kind Regards, >> Harish Sharma >> >> >> >> > > > -- > Thanks & Regards, > > Harmeet Singh > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
