Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-06 Thread kumar.ashish861
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

Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member July 2012

2012-08-06 Thread Amit Gandhi
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

Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member July 2012

2012-08-06 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

2012-08-06 Thread LAKSHMAN PRASAD
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:

Re: $$Excel-Macros$$ Fw: Urgent Help needed

2012-08-06 Thread francis vinod
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  

$$Excel-Macros$$ Excel formula / training material in ppt format

2012-08-06 Thread Amit Desai (MERU)
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

$$Excel-Macros$$ need help to send excel userform data to send email body...

2012-08-06 Thread Dhartikumar Sahu
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

Re: $$Excel-Macros$$ Run-time error popup message

2012-08-06 Thread Lokesh Loki
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

Re: $$Excel-Macros$$ Run-time error popup message

2012-08-06 Thread अनिल नारायण गवली
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,

$$Excel-Macros$$ Need help in mandays

2012-08-06 Thread Deepak Rawat
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

Re: $$Excel-Macros$$ Need help in mandays

2012-08-06 Thread Kuldeep Singh
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

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-06 Thread Venkat CV
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

Re: $$Excel-Macros$$ Need help in mandays

2012-08-06 Thread Ahmed Honest
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

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

2012-08-06 Thread Ashish Bhalara
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:

$$Excel-Macros$$ time counting macro........

2012-08-06 Thread Dhananjay Pinjan
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

$$Excel-Macros$$ Help with Formula Destination

2012-08-06 Thread Ashish Pradhan
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

RE: $$Excel-Macros$$ Data Entry Form

2012-08-06 Thread Rajan_Verma
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

Re: $$Excel-Macros$$ time counting macro........

2012-08-06 Thread ashish koul
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

Re: $$Excel-Macros$$ need help to send excel userform data to send email body...

2012-08-06 Thread ashish koul
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

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-06 Thread ashish koul
=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

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-06 Thread Sam Mathai Chacko
=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:

Re: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

2012-08-06 Thread pesh
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

Re: $$Excel-Macros$$ Help with Formula Destination

2012-08-06 Thread Kantilal Badale
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,

Re: $$Excel-Macros$$ Marquee text in Powerpoint

2012-08-06 Thread Rajasekhar Praharaju
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