working with share file is much diffcult to fix this problem in excel becouse every user will seat in different different pcs and everytime user have save the data to make the data sheet update my suguestion is this please user msaccess to perform this task
thank santosh bahuguna On 4/11/09, Harmeet Singh <harmeet.hew...@gmail.com> wrote: > 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 > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
