Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012
Dear Noorain, Congratulations Noorain! You are the shining star of this group.! keep it up. Cheers.! Thanks Ashish On Saturday, August 4, 2012 10:00:11 PM UTC-7, Andy wrote: Great Work Noorain!! Though I have been silent in this group for quite some time... However I keep following the posts.. almost everyday.. thx to great members like you, from whom I learn everyday...! Cheers and Keep up the good work, Regards, Andy On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita and other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Warm Regards, Aindril De Ph: 9811300157 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member July 2012
Congrats Noorain On Sun, Aug 5, 2012 at 11:41 PM, prkhan56 prkha...@gmail.com wrote: Great Work Noorain Bhai..Keep it up On Friday, August 3, 2012 9:40:25 PM UTC+4, Ayush Jain wrote: Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita and other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager Microsoft MVP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member July 2012
Thanks to all of you On Mon, Aug 6, 2012 at 12:12 PM, Amit Gandhi silkyro...@gmail.com wrote: Congrats Noorain On Sun, Aug 5, 2012 at 11:41 PM, prkhan56 prkha...@gmail.com wrote: Great Work Noorain Bhai..Keep it up On Friday, August 3, 2012 9:40:25 PM UTC+4, Ayush Jain wrote: Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita and other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager Microsoft MVP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
You are missing SUMPRODUCT((A7:A23E1)*(A7:A23F1)*(F7:F23)) Lakshman Prasad Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ From: Ashish Bhalara ashishbhalar...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, August 4, 2012 4:02 PM Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date Dear experts, I need output of sum between two date by using of Sumproduct as below formula but the error is occur in fuction, please see attache sheet. =SUMPRODUCT(A7:A23E1)*(A7:A23F1)*(F7:F23) Thanks regards. Ashish Bhalara 9624111822 PPlease do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Fw: Urgent Help needed
Hi Ashish, Thank you so much for your quick response. Yes, it did help, but the problem was when I tried to implement this formula in my work sheet, I am getting an error message, could you please advise what could be the reason for this error that would be great. Error Message =lookupall(C2,'Report 1'!$G$2:$K$5760,5) Thanks Regards, Francis From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 3 August 2012 10:35 PM Subject: Re: $$Excel-Macros$$ Fw: Urgent Help needed check the attachment see if it helps On Fri, Aug 3, 2012 at 7:05 PM, francis vinod francis_vi...@yahoo.co.in wrote: Hi Don, I never said my request is more urgent than other's request, since I didn't get any response to my earlier mail and I had to do some reporting so included the word 'urgent' in the subject line that's all. Thanks Regards, Francis From: dguillett1 dguille...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 3 August 2012 5:44 PM Subject: Re: $$Excel-Macros$$ Fw: Urgent Help needed Why is your request more urgent than the request of any of the others? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: francis vinod Sent: Friday, August 03, 2012 2:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fw: Urgent Help needed Hello Experts, Could you please provide me a solution on the below scenario. Thanks Regards, Francis - Forwarded Message - From: francis vinod francis_vi...@yahoo.co.in To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, 1 August 2012 6:54 PM Subject: Help needed Hello Team, Could you please help me in the below scenario. I have two different reports from which I have to prepare a single report for reporting purpose. In sheet 1 the reports contains tracking#, HW details etc. and sheet 2 the report contains the values of the HW, tracking # etc The report which I want should have the details of both Shee1 Sheet 2 for which I have used the Vlookup formula and its fine. The issue what I am facing is a single tracking # can have multiple line items and in the equipment report the equipments are split into seperate rows. For eg, If a tracking # has 5 different equipments with discreptions in 5 lineitems then when I use a VLookup formula it only shows the detail of equipment in 1st line. So I want your help on this so that I get all the 5 equipment details in my report. Please find attached the excel file with an example. If you could guide me it would be a great help and learning for me. Thanks Regards, Francis -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post
$$Excel-Macros$$ Excel formula / training material in ppt format
Dear Friends, Does any one have training material in ppt form for all excel formulas (basic Advanced)? If you please forward, this will help us to train others in the organization. Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ need help to send excel userform data to send email body...
hi expert guru's I want to send mail my userform data to my group mail id. how to write ma code to send my userform data. awaiting for your prompt reply. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Run-time error popup message
Hi All, It's urgent anybody please resolve my query. I hope all of you understand my concern. Regards Lokesh.M On Mon, Aug 6, 2012 at 11:18 AM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi All, From last week to till now i am sending mails to the group but till now i did not get any reply from the group. Only rajan has replied to my mail but 50% of the problem has been resolved and remaining still i am facing issue on VBA code. So team please resolve the vba code it would be very helpful to me get report ASAP. Regards Lokesh.M On Sat, Aug 4, 2012 at 10:40 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Rajan, I have replaced the error line and i got the exact employee's number of working days, but the 4 hrs of macro timings are not multiplied to those users. Please check and do the needful brother. Regards Lokesh.M On Sat, Aug 4, 2012 at 4:11 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Replace error line with this :* * * *.Offset(lngCellLoop, 1).Value = Format(CDate(.Offset(lngCellLoop, -1).Value + (4 * objDic.Count)), hh:mm:ss)* * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *lokesh *Sent:* 02 August 2012 5:59 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Run-time error popup message ** ** Hi All, When I am clicked the Get Report to know monthly report I got the error popup message window saying that “Run-time error’13 in VBA’” , hence I did not get the monthly report. Please find the above attached print screen of VBA line error and do the needful. ** ** ** ** Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Run-time error popup message
I didn't understand your remaining 50% query. Exactly what u want and how? Pl elaborate it... Regards, Gawli Anil On Mon, Aug 6, 2012 at 2:25 PM, Lokesh Loki wrote: Hi All, It's urgent anybody please resolve my query. I hope all of you understand my concern. Regards Lokesh.M On Mon, Aug 6, 2012 at 11:18 AM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi All, From last week to till now i am sending mails to the group but till now i did not get any reply from the group. Only rajan has replied to my mail but 50% of the problem has been resolved and remaining still i am facing issue on VBA code. So team please resolve the vba code it would be very helpful to me get report ASAP. Regards Lokesh.M On Sat, Aug 4, 2012 at 10:40 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Rajan, I have replaced the error line and i got the exact employee's number of working days, but the 4 hrs of macro timings are not multiplied to those users. Please check and do the needful brother. Regards Lokesh.M On Sat, Aug 4, 2012 at 4:11 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Replace error line with this :* * * *.Offset(lngCellLoop, 1).Value = Format(CDate(.Offset(lngCellLoop, -1).Value + (4 * objDic.Count)), hh:mm:ss)* * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *lokesh *Sent:* 02 August 2012 5:59 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Run-time error popup message ** ** Hi All, When I am clicked the Get Report to know monthly report I got the error popup message window saying that “Run-time error’13 in VBA’” , hence I did not get the monthly report. Please find the above attached print screen of VBA line error and do the needful. ** ** ** ** Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to
$$Excel-Macros$$ Need help in mandays
Hi, I have a data where i have to calculate mandays, i hv attached a sample data in which a field is Working/OFF What i need 1. I have to calculate mandays working day + one off or weekday. 2. i have to make a date wise pivot table in wich i want, 1 where working , off where off, WOFF where Weekly off sample of report is here as under: OUTLET NAME 23-Jun 24-Jun 25-Jun 26-Jun 27-Jun 28-Jun 29-Jun 30-Jun 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul Days SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN Vodafone (Dwarka) 1 1 1 OF 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (Vasant Vihar) 1 1 1 1 1 1 1 1 1 1 W.OFF 1 1 1 1 1 Vodafone (South Ext) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (Lajpat Nagar) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (C P) 1 W.OFF 1 1 1 1 1 1 W.OFF 1 1 1 1 1 1 W.OFF I am trying on pivot but its showing only count not the value. Database is huge more than 2 Lac so i need some technique which wl work shortly in precise way. Regards, Deepak -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Sample Data.xlsb Description: Binary data
Re: $$Excel-Macros$$ Need help in mandays
Hi Deepak, Please See attachment. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Aug 6, 2012 at 5:28 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi, I have a data where i have to calculate mandays, i hv attached a sample data in which a field is Working/OFF What i need 1. I have to calculate mandays working day + one off or weekday. 2. i have to make a date wise pivot table in wich i want, 1 where working , off where off, WOFF where Weekly off sample of report is here as under: OUTLET NAME 23-Jun 24-Jun 25-Jun 26-Jun 27-Jun 28-Jun 29-Jun 30-Jun 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul Days SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN Vodafone (Dwarka) 1 1 1 OF 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (Vasant Vihar) 1 1 1 1 1 1 1 1 1 1 W.OFF 1 1 1 1 1 Vodafone (South Ext) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (Lajpat Nagar) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (C P) 1 W.OFF 1 1 1 1 1 1 W.OFF 1 1 1 1 1 1 W.OFF I am trying on pivot but its showing only count not the value. Database is huge more than 2 Lac so i need some technique which wl work shortly in precise way. Regards, Deepak -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Sample Data Query Solved.xlsb Description: Binary data
Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012
Congrats Noorain. -- *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita and other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com * * * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Need help in mandays
Dear Deepak, Looking at your sample data one of your Outlet name : Janata Stores(S) starting from 9 to 15-Jul status is available only for 14 and 15-July as Off and Working, *what shall be considered as status for rest of the days i.e from 9 to 13-July ??* ** * * * * On Mon, Aug 6, 2012 at 2:58 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi, I have a data where i have to calculate mandays, i hv attached a sample data in which a field is Working/OFF What i need 1. I have to calculate mandays working day + one off or weekday. 2. i have to make a date wise pivot table in wich i want, 1 where working , off where off, WOFF where Weekly off sample of report is here as under: OUTLET NAME 23-Jun 24-Jun 25-Jun 26-Jun 27-Jun 28-Jun 29-Jun 30-Jun 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul Days SAT SUN MON TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN Vodafone (Dwarka) 1 1 1 OF 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (Vasant Vihar) 1 1 1 1 1 1 1 1 1 1 W.OFF 1 1 1 1 1 Vodafone (South Ext) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (Lajpat Nagar) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Vodafone (C P) 1 W.OFF 1 1 1 1 1 1 W.OFF 1 1 1 1 1 1 W.OFF I am trying on pivot but its showing only count not the value. Database is huge more than 2 Lac so i need some technique which wl work shortly in precise way. Regards, Deepak -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Ahmed Bawazir *احمد باوزير* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
Thanks to all, I make very silly mistake. On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: You are missing SUMPRODUCT((A7:A23E1)*(A7:A23F1)*(F7:F23)) *Lakshman Prasad* Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ -- *From:* Ashish Bhalara ashishbhalar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Saturday, August 4, 2012 4:02 PM *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two date Dear experts, I need output of sum between two date by using of Sumproduct as below formula but the error is occur in fuction, please see attache sheet. =SUMPRODUCT(A7:A23E1)*(A7:A23F1)*(F7:F23) Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ time counting macro........
Dear Experts, I need a macro which START counting from ZERO in hh:mm:ss: format. When I stop the STOP Macro Button, The counting also should have to stop. Ex - If I Start Macro, The cell should have to start counting '00:00:00' if I press 'STOP' Button after 5 Min. 45 Sec.' the cell figure should have to stop on 00:05:45. If again I click on START button, again cell should have start counting from '00:00:00'. Is it possible? Regards, Dhananjay -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Help with Formula Destination
Hello I have many cells with formulae in them in Sheet Main For Example: ='Staff Bonus'!E67 Is there a simpler way to go to the Sheet Staff Bonus and cell E67 from the Main sheet which contains this formulae? I think I was able to do this much earlier, but either I am mistaken or have simply forgotten. Any help / clarification would ease my work a lot and be highly appreciated. Just as an additional piece of information, I use Excel 2003 (SP3) -- Thanks Ashish Pradhan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
RE: $$Excel-Macros$$ Data Entry Form
Advance Option -Customize - All Command - Form Once you add form in any ToolBar, just select the heading and Click on that Form ICON , a user entry form will appear , you can enter the data , This form will consider Validation as well. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of trawets Sent: 06 August 2012 1:05 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Data Entry Form Hi bé trần văn Again thanks for your efforts in helping with this, I am struggling to incorporate this into my workbook, I have some 200 records already and expecting in the region of 3000 more, I have attached my file could you advise how I would include your code. hope you don't mind me asking this best regards On Sunday, August 5, 2012 6:04:13 PM UTC+1, trawets wrote: Thank you for your excellent response, I am currently trying to eveluate but it looks as though it does the job, will be back with more comments later. Again thanks for you time and assistance with this On Sunday, August 5, 2012 5:05:00 PM UTC+1, bé trần văn wrote: Do not know the request of you? 2012/8/5 trawets Hi Guys Could someone help with my problem, I have a simple defect recording spreadsheet, I would like to create a data entry form which I can do using the excel form command, however I would like to expand the functionality by having the number being displayed and being auto-number. some other fields I would like them to be list selection and dates (a calendar block would be nice). I know all this can be quite easily done using access but I'm not allowed to use this due to licencing restrictions below is a full list of the fields in the sheet any pointers would be appreciated DEFECT NUMBER _ Auto-number COMPARMENT DEFECT DEFECT CODE /TRADE PRIORITY _ List DATE RAISED Week No RAISED BY_ List STATUS _ List DATE CLEARED CLEARED BY _ List -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the
Re: $$Excel-Macros$$ time counting macro........
see if it helps On Mon, Aug 6, 2012 at 6:39 PM, Dhananjay Pinjan dppin...@gmail.com wrote: Dear Experts, I need a macro which START counting from ZERO in hh:mm:ss: format. When I stop the STOP Macro Button, The counting also should have to stop. Ex - If I Start Macro, The cell should have to start counting '00:00:00' if I press 'STOP' Button after 5 Min. 45 Sec.' the cell figure should have to stop on 00:05:45. If again I click on START button, again cell should have start counting from '00:00:00'. Is it possible? Regards, Dhananjay -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. sample.xlsm Description: Binary data
Re: $$Excel-Macros$$ need help to send excel userform data to send email body...
share the form and message On Mon, Aug 6, 2012 at 1:27 PM, Dhartikumar Sahu dhartiku...@gmail.comwrote: hi expert guru's I want to send mail my userform data to my group mail id. how to write ma code to send my userform data. awaiting for your prompt reply. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Help with Formula Destination
=HYPERLINK(#'SUBSTITUTE(CELL(address,Sheet2!A3),!,'!),Sheet2!A3) On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hello I have many cells with formulae in them in Sheet Main For Example: ='Staff Bonus'!E67 Is there a simpler way to go to the Sheet Staff Bonus and cell E67 from the Main sheet which contains this formulae? I think I was able to do this much earlier, but either I am mistaken or have simply forgotten. Any help / clarification would ease my work a lot and be highly appreciated. Just as an additional piece of information, I use Excel 2003 (SP3) -- Thanks Ashish Pradhan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Help with Formula Destination
=HYPERLINK(#CELL(address,Sheet3!A1),Sheet3!A1) Regards Sam Mathai Chacko On Mon, Aug 6, 2012 at 9:41 PM, ashish koul koul.ash...@gmail.com wrote: =HYPERLINK(#'SUBSTITUTE(CELL(address,Sheet2!A3),!,'!),Sheet2!A3) On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hello I have many cells with formulae in them in Sheet Main For Example: ='Staff Bonus'!E67 Is there a simpler way to go to the Sheet Staff Bonus and cell E67 from the Main sheet which contains this formulae? I think I was able to do this much earlier, but either I am mistaken or have simply forgotten. Any help / clarification would ease my work a lot and be highly appreciated. Just as an additional piece of information, I use Excel 2003 (SP3) -- Thanks Ashish Pradhan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells
This works great! Thank you! On Sunday, August 5, 2012 9:09:06 AM UTC-4, Don Guillett wrote: Or Sub SplitStringSAS() Dim VarArr With Selection VarArr = Split(.Value, |) .Resize(1, UBound(VarArr)).Value = VarArr End With End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Rajan_Verma rajanverma1...@gmail.com *Sent:* Sunday, August 05, 2012 12:48 AM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells *Hi* *Use this :* ** *Sub SplitString()* ** *Dim StrString As String* *Dim VarArr* *StrString = | ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|* *StrString = Mid(StrString, 2, Len(StrString) - 2)* *VarArr = Split(StrString, |)* *Range(A1).Resize(1, UBound(VarArr)).Value = VarArr* ** *End Sub* ** ** ** *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Alpesh Shah *Sent:* 05 August 2012 6:13 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells Dear Excel Experts, I am working with a string as follows: | ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf| There are a total of 8 pipes | . My issue is that I am trying to Split this based on the pipes, and output the words in between into cells. I have been trying to solve this for a long time with VBA, but I cannot seem to get it to succeed. Please help. Thank you. Alpesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Help with Formula Destination
Try CTRL+[ ] from formula cell CA Kantilal Badale E-Hall, First Floor, B. J. Market, Jalgaon.(Maharashtra) 9822250393 On Mon, Aug 6, 2012 at 10:08 PM, Sam Mathai Chacko samde...@gmail.comwrote: =HYPERLINK(#CELL(address,Sheet3!A1),Sheet3!A1) Regards Sam Mathai Chacko On Mon, Aug 6, 2012 at 9:41 PM, ashish koul koul.ash...@gmail.com wrote: =HYPERLINK(#'SUBSTITUTE(CELL(address,Sheet2!A3),!,'!),Sheet2!A3) On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hello I have many cells with formulae in them in Sheet Main For Example: ='Staff Bonus'!E67 Is there a simpler way to go to the Sheet Staff Bonus and cell E67 from the Main sheet which contains this formulae? I think I was able to do this much earlier, but either I am mistaken or have simply forgotten. Any help / clarification would ease my work a lot and be highly appreciated. Just as an additional piece of information, I use Excel 2003 (SP3) -- Thanks Ashish Pradhan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick
Re: $$Excel-Macros$$ Marquee text in Powerpoint
Ashish, any idea in this regards as already you have created in excel. Thanks for your help in advance!! On Sat, Aug 4, 2012 at 3:46 AM, David Grugeon da...@grugeon.com.au wrote: You might do better asking PowerPoint questions on a Powerpoint forum. As its name indicates this forum is about Excel Macros. On 4 August 2012 02:24, rekha siri rekha.siri2...@gmail.com wrote: Hi Experts, Please assist in this concern i deal with xlius earlier now we are using only power point dashboard presentation. is there any possibility to place the scrolling marquee kind of text as Headings of power point slides. which needs to be scrolling continously. Thanks, Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Regards David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- Thanks Regards, Rajasekhar.P Subscribe to our group and receive daily updates. Excel groups https://sites.google.com/site/excelencyclopedia/how-to-join/assignments Send your queries and Suggestions @ excel-gro...@googglegroups.com Excelforum Blogspot a href= http://feedburner.google.com/fb/a/mailverify?uri=ExcelForumamp;loc=en_UShttp://feedburner.google.com/fb/a/mailverify?uri=ExcelForumloc=en_USSubscribe to excel forum by Email/a -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.