Hi Harmeet, I used the other macro to fix my date and time issue since I was trying to link this date and time with availble field in raw data but this was refreshing so time was also refreshed but anyway I have fixed that but eventually I have found that the data acquired is always misses the first raw and name of the agent which comes in raw data sheet is not correct as it comes against the one row prvious data.
I have also not able to get mys in your macro. Once again thanks for your time Regards, Harish 2009/4/13 Harmeet Singh <harmeet.hew...@gmail.com> > 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 > > > > -- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
