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