Hi Magandeep, I am also a CA practicing in Pune..I am not an expert, but sometimes do coding for enjoyment. I have a lot of such small assignments, for my daily requirements. If you are interested, I can share you some tips.. Before that let me know what do you do and some words about yourself.
Of course if you wish so.. Thanks Tushar ACA On Fri, Jul 2, 2010 at 1:08 PM, CA MAGAN <magandeepc...@gmail.com> wrote: > DEAR SIR > > > > I HAVE ALREADY SEND A SAMPLE FILE BUT I HAVE NOT RECEIVED ANY REPLY FROM > ANY OF THE MEMBERS OF THIS ESTEEMED GROUP. > > > > I AM FORWARDING A SAMPLE DATA FILE. PLEASE GUIDE ME ABOUT THIS AS PER THE > FOLLOWING REQUIREMENTS:- > > > > THE EXCEL FILE IS FOR TASKS TO BE PERFORMED IN AN OFFICE. WHEN ANY TASK > COMES IT WILL BE ADDED IN EXCEL SHEET NAMED AS MASTER BY ASSIGNING NATURE OF > JOB , TO WHOM IT IS ASSIGNED, PRIORITY. (YOU CAN SEE MASTER SHEET IN > WORKBOOK ATTATCHED). AFTER THAT THE DATA SHOULD AUTOMATICALLY GO TO > DIFFERENT WORKSHEETS AS PER THE NAME OF THE EMPLOYEES. THE EMPLOYEE AT THE > END OF DAY OR AT ANY POINT OF TIME WILL UPDATE THE DATA IN HIS NAMED SHEET > WITH STAGE OF COMPLETION OF TASK, TIME REQUIRED TO COMPLETE IT ETC. THIS > DATA SHOULD AUTOMATICALLY UPDATE IN MASTER SHEET. HOW TO DO IT. > > > > PLEASE REPLY > > > > THANKS AND REGARDS > > > > CA MAGAN DEEP AGGARWAL > > B.COM, FCA, ISA(ICAI) > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of * > excel-macros+nore...@googlegroups.com<excel-macros%2bnore...@googlegroups.com> > *Sent:* Tuesday, June 29, 2010 5:19 AM > *To:* Digest Recipients > *Subject:* $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 16 > Messages in 7 Topics > > > > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > - INFORMATION REQUIRED <#1299238c51baeccd_group_thread_0> [3 Updates] > - Index match multiple <#1299238c51baeccd_group_thread_1> [3 Updates] > - Required Formula <#1299238c51baeccd_group_thread_2> [4 Updates] > - Trend formulaes <#1299238c51baeccd_group_thread_3> [1 Update] > - Select files via checkboxes, then copy those files to a new > directory<#1299238c51baeccd_group_thread_4>[1 Update] > - Radio button gets protected <#1299238c51baeccd_group_thread_5> [3 > Updates] > - Help in MS Word macro <#1299238c51baeccd_group_thread_6> [1 Update] > > Topic: INFORMATION > REQUIRED<http://groups.google.com/group/excel-macros/t/851a2c231eb3e153> > > *CA MAGAN DEEP AGGARWAL <magandeepc...@gmail.com>* Jun 27 07:39PM -0700 > ^<#1299238c51baeccd_digest_top> > > > DEAR MEMBERS > > I WANT TO CREATE A WORKBOOK CONTAINING DIFFERENT WORKSHEETS. FIRST > WORKSHEET WILL BE A MASTER WORKSHEET AND ALL OTHER WORKSHEETS ARE PART > OF THE FIRST OR MASTER WORKSHEET. THE DATA OF OTHER WORKSHEETS SHOULD > GET VALUE FROM MASTER WORKSHEET DEPENDING UPON A SINGLE CELL VALUE > WHICH IS A TEXT OR NAME OF A EMPLOYEE. ALL OTHER WORKSHEETS ARE ALSO > NAMED AS EMPLOYEE NAMES. THE INFORMATION IN THESE WORKSHEETS SHOULD > GET VALUE FROM MASTER WORKSHEETS DEPENDING UPON THE NAME OF THE > EMPLOYEE. PLEASE GUIDE ME FOR THIS. THANKS IN ADVANCE. > > REGARDS > > CA MAGAN DEEP AGGARWAL > > > > *Ayush <jainayus...@gmail.com>* Jun 27 09:10PM -0700 > ^<#1299238c51baeccd_digest_top> > > > Dear Magan, > > It would be easier to help if you can provide some sample data in > excel sheet. > > This problem can easily be solved by using vlookup, index, match > functions of excel. > Also, A macro can be written to automate this completely. > > Hope it helps. > > Best Regards, > Ayush Jain > > > On Jun 28, 7:39 am, CA MAGAN DEEP AGGARWAL <magandeepc...@gmail.com> > wrote: > > > > *Aindril De <aind...@gmail.com>* Jun 29 12:00AM +0530 > ^<#1299238c51baeccd_digest_top> > > > Hi Magan, > Can u please send a sample file > Regards, > Andy > > On Mon, Jun 28, 2010 at 8:09 AM, CA MAGAN DEEP AGGARWAL < > > > > Topic: Index match > multiple<http://groups.google.com/group/excel-macros/t/f8e32a4e2d180365> > > *Nadine S <n8dine4ma...@yahoo.com>* Jun 27 09:01PM -0700 > ^<#1299238c51baeccd_digest_top> > > > It didn't work on my actual data. It could be that part of it is looking > to a formula result. I've attached the file in hopes that someone can, at a > minimum, help with the formula for the green cells. However, if someone > wants to take it a bit farther, I would love someone to also look at the > second tab and look at the yellow cells to see if the formulas can be > improved. Thanks so much. > Nadine > > > > > ________________________________ > From: Dilip Pandey <dilipan...@gmail.com> > To: excel-macros@googlegroups.com > Cc: n8dine4ma...@yahoo.com > Sent: Sat, June 26, 2010 10:59:55 PM > Subject: Re: $$Excel-Macros$$ Index match multiple > > Hi Nadine, > > Attached file is solved as per your requirements. > check the file and revert in case of any questions. :) > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > > > *Dilip Pandey <dilipan...@gmail.com>* Jun 28 06:12PM +0530 > ^<#1299238c51baeccd_digest_top> > > > Hi Nadine, > > I have applied my formula to your spreadsheet and now it is working fine. I > think you forgot to check the data range reference in the formula. > > Please check the attached file and let me know if this helps. > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > > > > *Dilip Pandey <dilipan...@gmail.com>* Jun 28 11:09PM +0530 > ^<#1299238c51baeccd_digest_top> > > > You are always welcome. . !! > > Thx, > DiLipandey > > >>> they > >>> can subscribe to group at > >>> http://groups.google.com/group/excel-macros/subscribe > > -- > Sent from my mobile device > > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > > Topic: Required > Formula<http://groups.google.com/group/excel-macros/t/eb4b521cb3a1bd1b> > > *Ahmedhonest <ahmedhon...@gmail.com>* Jun 27 10:32PM +0300 > ^<#1299238c51baeccd_digest_top> > > > Hai Dilip Ji, > > I have removed the pivot and kept the desired output that i require, please > add your valuable ideas and suggestions, I have attached the file. > > Waiting in anticipation................................. > > Regards > Ahmed Bawazir > > > -- > Ahmed Bawazir > > > > *Dilip Pandey <dilipan...@gmail.com>* Jun 28 05:15PM +0530 > ^<#1299238c51baeccd_digest_top> > > > Hi Ahmed... the Honest Man.. :) > > Attached file is solved as per your requirements. > > Let me know if this helps you, get back in case of queries. > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > > > *Ahmedhonest <ahmedhon...@gmail.com>* Jun 28 04:23PM +0300 > ^<#1299238c51baeccd_digest_top> > > > Dear Dilip bhai, > > > > Your Formula is cool but still the desired output is correct to some extent > and part of it remains inconsistent. > > > > To give you a quick snap of the output, if you see the *Pers. No 5* Details > are as follows in Raw Data Sheet: > > > > Passport > > 0920838M > > Iqama > > 2030944801 > > GOSI > > 804733221 > > > But in the Required Output sheet it is : > > Pers.No. > > Personnel Number > > Baladiah Card > > GOSI > > Iqama > > National ID > > Passport > > 5 > > Sekera curuppu Lesley Nandasena > > 0 > > 804733221 > > 2030944801 > > 0 > > 0 > > *Output I need is as below*** > > Pers.No. > > Personnel Number > > Baladiah Card > > GOSI > > Iqama > > National ID > > Passport > > 5 > > Sekera curuppu Lesley Nandasena > > 0 > > 804733221 > > 2030944801 > > 0 > > 0920838M > > > > So the formula is part working okay and part is inconsistent. > > I hope this can be achieved by Index and match formula, please be patient > in > providing me your valuable suggestions and ideas. > > Thanks a lot for your time. > > Regards > > Ahmed HONEST MAN [?] > > > > -- > Ahmed Bawazir > > > > *Dilip Pandey <dilipan...@gmail.com>* Jun 28 09:03PM +0530 > ^<#1299238c51baeccd_digest_top> > > > Will check and revert..!! > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > > > > Topic: Trend > formulaes<http://groups.google.com/group/excel-macros/t/c6d3488ee7b3c3a> > > *Abhidha Dixit <abhidha.di...@gmail.com>* Jun 28 05:01PM +0530 > ^<#1299238c51baeccd_digest_top> > > > ---------- Forwarded message ---------- > From: Abhidha Dixit <abhidha.di...@gmail.com> > Date: Mon, Jun 28, 2010 at 4:54 PM > Subject: Trend formulaes > To: excel-macros@googlegroups.com > > > Dear ALL > > Can you please check if i va done it in the right manner , if not correct > please let me know the right way > I want to know the trend of booking on the perticular days as an 1-15 and > 16-27 weather it is +ive or -ive > > Rgards > Abhidha, > > > > Topic: Select files via checkboxes, then copy those files to a new > directory <http://groups.google.com/group/excel-macros/t/b691b42d8b50c40e> > > *yogananda muthaiah <yogananda.mutha...@gmail.com>* Jun 28 11:02AM +0500 > ^<#1299238c51baeccd_digest_top> > > > Hi paul, > after opening the userform file, i am getting as runtime error. I am > using excel 2007... > Chk n tel me the solution to open dat file > > > -- > Sent from my mobile device > > > > Topic: Radio button gets > protected<http://groups.google.com/group/excel-macros/t/e7e4f1ca73456942> > > *"L.K. Modi" <ca.mod...@gmail.com>* Jun 28 10:28AM +0530 > ^<#1299238c51baeccd_digest_top> > > > Dear all > > As per your mail i am unable to find what is the radio buttons. as i m new > to excel. > can any one suggest the entire procedure regarding these radio buttons and > use. > > pls ignore the mail if i have already sent the mail. I want to know the > step > by step procedure regarding these buttons > > > Thanks in advance hope i wil get the reply fast. > > > Regards > LKModi > > > > > > > > > > > *"L.K. Modi" <ca.mod...@gmail.com>* Jun 28 10:23AM +0530 > ^<#1299238c51baeccd_digest_top> > > > Dear all > > As per your mail i am unable to find what is the radio buttons. as i m new > to excel. > can any one suggest the entire procedure regarding these radio buttons and > use. > > Thanks in advance hope i wil get the reply fast. > > > Regards > LKModi > > > > > > > > > > *rf1234 rf1234 <rfhyd1...@gmail.com>* Jun 28 12:01PM +0530 > ^<#1299238c51baeccd_digest_top> > > > Hello Dear, > Go through the attached Workbook. Hope it will let you proper understand > about > The form control. > > > > > 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 > > -- > Regards, > Prashant Tripathi > Engineer-SW > Mobile: 0017202597567 > Please consider the environment before printing. > ---------------------------------------------------- > Immer zielen auf die vollkommene Harmonie des > Denkens & Wort & deed.Always zielen darauf ab, > reinigen Sie Ihre Meinung und alles wird gut. > ---------------------------------------------------- > Always aim at complete harmony of thought & > word & deed.Always aim at purifying your > thoughts & everything will be well. > > > > Topic: Help in MS Word > macro<http://groups.google.com/group/excel-macros/t/af6a66b8fd056767> > > *Nagendra Modupalli <naga14...@gmail.com>* Jun 28 08:48AM +0530 > ^<#1299238c51baeccd_digest_top> > > > Hi Team, > > I have MS Word Invoices monthly more than 10,000,Those invoice am spooling > from DB2 system when i spooled the alignment is not correct for that am > doing Enter or Backspace to get correct alignment.Is there MS word > Alignment > macro to invoices. > > Can you please help me on this.Thanks in advance. > > -- > Thanks&Regards > Nagendra.M > > "Beautiful photos are developed by negatives in a dark room, so if U see > darkness in Ur life believe that God is making a beautiful future for U !!! > > > > -- > > ---------------------------------------------------------------------------------- > 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 7000 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 > > -- > > ---------------------------------------------------------------------------------- > 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 7000 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 > -- Regards Tushar S Patki Contact Details - 2106, Sadashiv Peth, Dattaprasad Apartment, Pune - 411030. State: Maharashtra Country: India Phone - +91-020-24337003 Mobile - 09850715116 -- ---------------------------------------------------------------------------------- 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 7000 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
