$$Excel-Macros$$ Re: Urgent help required in vba coding!!!!!!!!!!!!!!!!!!!!!
Quick reply for 2nd point: IN VBE, Select: Tools / VBA Project Propoerties / Protection Now enable Lock Project for Viewing, enter password twice and click on OK. Most Imp: Do not forget the passowrd. regards, Milind On Mar 6, 3:52 pm, Indrajit $nai talk2indra...@gmail.com wrote: Hi All, I need a urgent help! I am creating a *Login Time tracke*r in excel with vba, but I stuck with a problem. For that reason I need your help. Please see the attach file. My requirement: 1. When ever I am clicking on Save (checkbox) there should be value (from e3:j3) other wise it will show me a error message, and don't let me save. 2. Is there any option so that no one can see the vba coding except me? Need your help VBA GURU'S. Thanking you. -- Indra talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. LOGIN TIME TRACKER.xls 145KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Urgent Help Required in a macro
Hi ZAC, I have created a user form as per your needs. The shortcut is CTRL + Y and userform will pop up on this shortcut. The data will be updated on click of submit button. The fields will reset on data successfully updated. Please have a look and let me know if any further assistance is required. It appears to me that this can be done in much better way rather than updating each value. If you have any logic to update the data from one place to another, We can help you doing same. Do let us know with relevant data, if you have any questions. Best regards, Ayush Jain Group Manager On Tue, Apr 20, 2010 at 5:25 PM, Chaudhry Zahid Ali chaudhry.zahid@gmail.com wrote: Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would contain Replace item from column, where I can write, for example G, and the third field containing an other Replace item from column for example AA. In this case the VBA code should select cells G3 and AA3. Than when I press enter or a button on the excel sheet the contents of cell G3 should go to AA3 and contents of AA3 should go to G3. The dialogue should not close after the cell contents have been replaced, but should close upon clicking the cross because there would be mutiple entries that need correction. An urgent reply and help would be highly appriciated, I have very little time to do tjis HUGE task of finding and replacing data in excel. Thanks in advance and Regards, ZAC. -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Chaudhry.xlsm Description: Binary data
$$Excel-Macros$$ RE: Urgent help required with Date/Time Format-DisRegard
Hi All, Apologies for sending this request. I seem to have found out the solution. I wasted one whole hour trying to figure out something which was simple, but I seem to have over looked how the formatting is done. Please do not waste your time on this request. Apologies once again. Kind regards, Amitabh From: amitabhbo...@hotmail.com To: excel-macros@googlegroups.com Subject: Urgent help required with Date/Time Format Date: Fri, 7 Aug 2009 10:15:10 + Hi All, I would be grateful if you could help me out with the following problem I am facing with regard to data formatting: The changes I need to make to the file are as follows: 1. I need to deduct one hour from the 'CaptureTime' field(column E) which is in seconds. This I have done by deducting 3600seconds. I have then divided this by 86400 to allow for the column to be formatted into hh:mm:ss 2. I then need to use this column and concatenate this field to the 'CaptureDate' field and get a field which is similar to the data in 'column G'. The problem I am facing is formatting the data to '-MM-DD hh:mm:ss'. I have attached a file with sample data. Many thanks, Amitabh Match ‘n’ Make new friends with the cool match-meter. Join the Planet with you Hotmail ID. Drag n’ drop _ Log on to MSN India for a lowdown on what’s hot in the world today http://in.msn.com --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: urgent Help Required
Hi, Use text to column wizard in 3rd step select date and DMY format all your dates will be converted to data format Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of sachin patil Sent: 13 July 2009 PM 03:00 To: Excel Subject: $$Excel-Macros$$ urgent Help Required Hi, I'm Very new for this group.I'm facing problem in Excel in Date Formatting. When I'm Selecting to Column go to Option of Date in Format, Whole column is not coming accoroding to that selected Date Format. Can anybody help me out in this ? Thanks in Advance Sachin Patil Dreams are today's answers to tomorrow's questions The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: urgent Help Required
Hi Sachin, You have entered date which seems as date but actually are strings. You have to write dated in the format mm/dd/yy. So your date should be 03/31/09, not 31-03-09. This will solve your problem Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don't. - From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of sachin patil Sent: Monday, July 13, 2009 3:00 PM To: Excel Subject: $$Excel-Macros$$ urgent Help Required Hi, I'm Very new for this group.I'm facing problem in Excel in Date Formatting. When I'm Selecting to Column go to Option of Date in Format, Whole column is not coming accoroding to that selected Date Format. Can anybody help me out in this ? Thanks in Advance Sachin Patil Dreams are today's answers to tomorrow's questions --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
Hello, Plz let me know below query. On Thu, Jul 2, 2009 at 2:26 PM, vinod rao vinod.ma...@gmail.com wrote: Hello, Can i know how was radio icon created linked to year 1,2 3.? Thanks in advance. Vinod On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla sachina...@gmail.comwrote: Dear Dilip, Thanks a lot. Its working. Thanks Sachin Shukal On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Sachin, Attached sheet has been solved. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jun 30, 2009 at 11:53 AM, Sachin Shukla sachina...@gmail.comwrote: Dear All, Please provied me help on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~ -- 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 HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
Hi Sachin, Attached sheet has been solved. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jun 30, 2009 at 11:53 AM, Sachin Shukla sachina...@gmail.comwrote: Dear All, Please provied me help on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~--- Book1-by-DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Urgent Help Required
Dear Dilip, Thanks a lot. Its working. Thanks Sachin Shukal On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Sachin, Attached sheet has been solved. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jun 30, 2009 at 11:53 AM, Sachin Shukla sachina...@gmail.comwrote: Dear All, Please provied me help on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help required!!!! Please help!!!
Hi Dilip, Thanks a lot for your respose. This is something which i am expecting to perform. However, i forgot to mention one thing in my previous mail. It would be great if a macro could be created, where all these things (which you have made in the file) could be automatically keeping in mind that there is only one sheet (sheet 1 which has the data) and therefore, sheet 3 is created by macro. Please let me know if you have any questions. Thanks a lot again for your support. You Rock!!! Thanks Regards Ankit Mehra On 6/29/09, Dilip Pandey dilipan...@gmail.com wrote: Hi Ankit, Please find the solution attached. Solution is provided only for Task B. Look into this and me know, if we can go-ahead with this. Thanks, Dilipandey -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Jun 29, 2009 at 12:53 PM, Ankit Mehra ankitmehr...@gmail.comwrote: Hello Group, In order to explain my problem, Attached is the file for your reference. In the attached file, there are two sheets (sheet1 and sheet3). The user inputs the data in sheet1 basis the task and start and end date. Now, based on the data on this sheet, i want excel macro to automatically highlight the cell at the intersection based on the value in column (i.e. Task) and row (based on the timelines). For example: Task A begins on 11-May and ends on 11-June. So, this macro should select the intersection cells based on these two conditions, merge them, then fill the background color, enter the total time assigned to this task (which is 4 weeks) in this case, and then create a border for this cell. This has to be applied for all the cells basis the task and their timelines. I hope my query is clear. Your response would be highly appreciated. -- Thanks Regards Ankit Mehra -- --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help required
Can you please send the sample text file.. Regards, Andy On Fri, Jun 12, 2009 at 8:10 AM, Balachander S sba...@gmail.com wrote: May be this is very simple for you experts . I am unable to crack the converiosn from Test file to excel for the data below. The fields are not aligned to draw column lines for import the dtat is not of conistent length. Only patterm I see is the text and numeric data nd spaces in between (these are also not uniform) Any help possible as to how I proceed sba...@gmail.com Br Name AcNo Title LimitExcess ACBalance r p road 1 god brother100 2919.58 1002919.58 mysore 1 reliance star7400 100869954.98 100869954.98 tatabad ist street 12345 satyam computers p ltd 2250 14480 22514480 --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
Good idea, but we can come out of that situation. Harish, Just put a line in the macro before msgbox: activeworbook.save hope that solves the issue On Tue, Apr 14, 2009 at 8:55 PM, santosh bahuguna santoshbahug...@gmail.com wrote: 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.comwrote: Hi Ashish, Can you please help me with the file attached. I have raw data in first sheet columns B,CD 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 -- 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
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.comwrote: Hi Ashish, Can you please help me with the file attached. I have raw data in first sheet columns B,CD 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
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.comwrote: 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,CD 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
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.comwrote: 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,CD 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help Required
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,CD 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 - -~--~~~~--~~--~--~---