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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
