Re: $$Excel-Macros$$ Linking of Excel data to powerpoint file

2012-07-20 Thread David Grugeon
Hi Amit You should be able to use Paste Special - Link in Powerpoint. Kind regards David Grugeon On 21 July 2012 13:49, Amit Desai (MERU) wrote: > Dear Masters, > > ** ** > > We used to keep updating tables in excel sheet & then used to paste this > tables in ppt. > > ** ** > > Is t

Re: $$Excel-Macros$$ Please help..

2012-07-20 Thread Manoj Kumar
ok thanks On Fri, Jul 20, 2012 at 6:00 PM, NOORAIN ANSARI wrote: > Manoj Please change reference of range, As per need otherwise it will show > same result. > > > On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar > wrote: > >> Dear Noorain Ji, >> >> when i drag this formula it show same result... >>

$$Excel-Macros$$ Linking of Excel data to powerpoint file

2012-07-20 Thread Amit Desai (MERU)
Dear Masters, We used to keep updating tables in excel sheet & then used to paste this tables in ppt. Is there any way to avoid this copy paste activity. If we can just update excel & that gets populated in ppt! I asking for a linking of excel data to ppt. Is it possible? If yes, Please expla

Re: $$Excel-Macros$$ Required some MS Excel question for interview.

2012-07-20 Thread Indrajit $nai
Thanks a lot Noorain. :) On Fri, Jul 20, 2012 at 9:52 AM, NOORAIN ANSARI wrote: > Dear Indrajit, > > PFA > > > On Fri, Jul 20, 2012 at 9:48 AM, Indrajit $nai wrote: > >> Thanks Noorain, but please send me the Answer paper also. :) >> >> >> On Fri, Jul 20, 2012 at 8:07 AM, NOORAIN ANSARI

$$Excel-Macros$$ Excel 2010: Review each cell in a spreadsheet, Parse it, Rejoin it in Spreadsheet

2012-07-20 Thread Alpesh Shah
Dear Excel Experts, I have attached a spreadsheet with dummy data. The first tab shows the dummy information and the second tab shows what I would like it to look like. As I have over 100 of rows of data to do this for, I am looking to develop some vba code to help accelerate the work. Each row on

$$Excel-Macros$$ Format Shape Style Dialog in XL2007, 2010

2012-07-20 Thread debdarshan
hey! good work... i have a question How to display the *Format > Shape Style Gallery* ** **through VBA - i.e. in the lines of *1. Application.Dialogs(xlDialogFormatFont).Show* *2. Set Cmd = Application.CommandBars(1).FindControl _* * (Type:=1, ID:=256, Recursive:=True)* *

$$Excel-Macros$$ Kindly advise on chart

2012-07-20 Thread Aruna jayaram
Hi Kindly advise how in the same chart data can be shown also depicting the point of increase i.e., the increase in volume also being shown in the same chart. Thanks Aruna -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ How To Create DynamicChart

2012-07-20 Thread Ashish kumar
Dear Noorain, Thanks for the valuable feedback. Thanks Ashish kumar On 20 July 2012 18:16, NOORAIN ANSARI wrote: > Dear Ashish, > > Please visit Chandoo website, it is good a resource to know regarding > dynamic chart. > > Link is below > > http://chandoo.org/wp/2009/05/19/dynamic-charts-in-e

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-20 Thread jmothilal
spellnumber function working only number to text only On Fri, Jul 20, 2012 at 5:17 PM, Ashish kumar wrote: > Dear All, > > Greetings for the day...! > > > I have trying to convert Text to numbers (digits), and I h've apply the > formula (spellnumber), but this is not working. please

$$Excel-Macros$$ Re: Error Cleaning

2012-07-20 Thread SG
hi pascal, i didn't understand this part of code...what should i write if i run this macro in new workbook Set wbIn = Workbooks("Book1 - Copy.xlsm") 'Set wsInOut = wbIn.Worksheets.Add: wsInOut.Name = "sorted data ok2" Set wsInOut = wbIn.Worksheets("sorted data") Set wsIn = wbIn.Worksheets("sp

Re: $$Excel-Macros$$ How To Create DynamicChart

2012-07-20 Thread NOORAIN ANSARI
Dear Ashish, Please visit Chandoo website, it is good a resource to know regarding dynamic chart. Link is below http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/ On Fri, Jul 20, 2012 at 6:14 PM, kumar.ashish861 wrote: > Dear Champs, > > kindly help me to create Dynamic Chart & give som

$$Excel-Macros$$ How To Create DynamicChart

2012-07-20 Thread kumar.ashish861
Dear Champs, kindly help me to create Dynamic Chart & give some knowledge about the tools and functions, define the tool names and how to use these tools & functions to create dynamic charts. Thanks in advance..! Thanks & Regards Ashish Kumar -- -- FORUM RULES (986+ members alrea

Re: $$Excel-Macros$$ Please help..

2012-07-20 Thread NOORAIN ANSARI
Manoj Please change reference of range, As per need otherwise it will show same result. On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar wrote: > Dear Noorain Ji, > > when i drag this formula it show same result... > > > On Fri, Jul 20, 2012 at 5:52 PM, NOORAIN ANSARI > wrote: > >> Dear Manoj, >> >>

Re: $$Excel-Macros$$ Help Me

2012-07-20 Thread dguillett1
“Please help me” is NOT a good subject line. Please describe your problem in the body of your email and also attach file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Manoj Kumar Sent: Friday, July 20, 2012 12:43 AM To: excel-macros@googlegroups.com Subje

Re: $$Excel-Macros$$ Please help..

2012-07-20 Thread NOORAIN ANSARI
Dear Manoj, Please see attachment without Array Function. On Fri, Jul 20, 2012 at 5:36 PM, Manoj Kumar wrote: > Dear Noorain Ji, > > Thanks for reply > > Your formula is correct but can you do it without Erry.. > > Regard > Manoj > > > On Fri, Jul 20, 2012 at 4:08 PM, NOORAIN ANSARI > wrote: >

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-20 Thread Ashish kumar
Dear All, Greetings for the day...! I have trying to convert Text to numbers (digits), and I h've apply the formula (spellnumber), but this is not working. please help me to convert this, & is this possible to convert it with formula not with the help of VB codeing. Example :- Four T

Re: $$Excel-Macros$$ need to consolidate data in one sheet

2012-07-20 Thread सुनिता पौडेल
Thank you soo much I will try it have a nice weekend Sunita On Fri, Jul 20, 2012 at 5:16 PM, Deba Ranjan wrote: > Hi Sunita Ji, > > PFA... might help you out your Query. > > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Fri, Jul 20, 2012 at 2:41 PM, सुनिता पौडेल wrote: > >>

Re: $$Excel-Macros$$ Please help..

2012-07-20 Thread NOORAIN ANSARI
Dear Manoj, Please see attached sheet, Change range as per State Name Hope it help to you. On Fri, Jul 20, 2012 at 11:24 AM, Manoj Kumar wrote: > Dear Noorain Ji. > > I need 1st,2nd and 3rd Max sealing model name in every state... > > Regard > Manoj > > > On Fri, Jul 20, 2012 at 11:21 AM, NOORA

$$Excel-Macros$$ need to consolidate data in one sheet

2012-07-20 Thread सुनिता पौडेल
Dear all, In this attached file there is data in one sheet 1, I want the same account head amount from the sheet 1 to appear in sheet 2. Is it possible?. I tried manually but takin time so if you all could help me on this. Thank you very much for the cooperation. Regards, Sunita -- -- FORUM

Re: $$Excel-Macros$$ regarding ratio

2012-07-20 Thread सुनिता पौडेल
thank you Noorain ji !! On Fri, Jul 20, 2012 at 8:45 AM, NOORAIN ANSARI wrote: > Hi Sunita, > > Try this one > > *=SUBSTITUTE(TEXT(A1/B1,"?/?"),"/",":")* > or > > *=ROUND(A1/B1, 2) &":" & ROUND(B1/A1,2)* > > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelvbaclinic.