Re: $$Excel-Macros$$ Re: Query on Text to Columns function

2013-08-31 Thread De Premor
Try this code Sub Macro1() Dim Data As Range Application.DisplayAlerts = False Set Data = Range("C2", Range("C2").End(xlDown).Address) Data.TextToColumns Data.Offset(, 1), OtherChar:=".", FieldInfo:=Array(Array(1, 2), Array(2, 2), Array(3, 2)) Application.DisplayAlerts = Tru

$$Excel-Macros$$ Re: Query on Text to Columns function

2013-08-31 Thread PoojaSharma
Thanks Lalit for the solution, though the solution to my query is quite simpler..while using text to column on the very next step choose text for each column within text to column window. Regards Pooja Sharma Sent from my iPad On Aug 29, 2013, at 2:09 PM, Lalit Mohan Pandey wrote: > Tr

$$Excel-Macros$$ Fwd: Microsoft Excel Re: vlook up button for single click

2013-08-31 Thread Pravin Gunjal
-- Forwarded message -- From: veeru Date: Fri, Aug 30, 2013 at 8:15 PM Subject: Microsoft Excel Re: vlook up button for single click To: microsoft-office-2...@googlegroups.com no one solved my problem? On Monday, August 19, 2013 12:40:44 PM UTC+5:30, veeru wrote: > >

Re: $$Excel-Macros$$ Interactive Dashboards

2013-08-31 Thread Priyanka Sachdeva
The Sales Dashboard totally works for me !!!..pretty interesting stuff..Thanks a lot for this help again Regards, On Saturday, August 31, 2013 8:19:24 PM UTC+5:30, ashish wrote: > > Hi try these links see if it helps > > http://chandoo.org/wp/2010/01/04/sales-dashboards/ > > http://chandoo.org/w

Re: $$Excel-Macros$$ Interactive Dashboards

2013-08-31 Thread Priyanka Sachdeva
That was quick !!!..Thanks a lot ..will check out the links On Saturday, August 31, 2013 8:19:24 PM UTC+5:30, ashish wrote: > > Hi try these links see if it helps > > http://chandoo.org/wp/2010/01/04/sales-dashboards/ > > http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-temp

Re: $$Excel-Macros$$ Interactive Dashboards

2013-08-31 Thread ashish koul
Hi try these links see if it helps http://chandoo.org/wp/2010/01/04/sales-dashboards/ http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-templates-grab-now-and-become-a-charting-superman/ http://chandoo.org/wp/2011/03/22/customer-service-dashboard/ http://www.excelhero.com/blog/

$$Excel-Macros$$ Interactive Dashboards

2013-08-31 Thread Priyanka Sachdeva
Hello All, Not sure if this has been discussed here before, also went through some other forums on googlegroups without any help. I am looking for Interactive Dashboard templates along with some tutorials on how to go about modifying or customizing them. Need it majorly to show region wise sal

$$Excel-Macros$$ Calculate break time Production time after removing break time

2013-08-31 Thread santosh subudhi
Hi Group, I have been trying to calculate the actual production time with certain conditions to it . Attached is the sample sheet with an example and conditions. -- Regards Santosh santoshkumar.subu...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TI

Re: $$Excel-Macros$$ Formulae for Removing Certain Word from Sentance

2013-08-31 Thread ravinder negi
pls use below formual. =SUBSTITUTE(SUBSTITUTE(A1,"RUPEES ",""),"PAISAS ","") From: mehtab shaikh To: excel-macros@googlegroups.com Sent: Saturday, August 31, 2013 12:59 PM Subject: $$Excel-Macros$$ Formulae for Removing Certain Word from Sentance Dear Ex

Re: $$Excel-Macros$$ Formulae for Removing Certain Word from Sentance

2013-08-31 Thread ashish koul
=SUBSTITUTE(SUBSTITUTE(A1,"Rupees",""),"PAISAS","") see if it helps On Sat, Aug 31, 2013 at 12:59 PM, mehtab shaikh wrote: > > Dear Experts, > > Please find enclosed example sheet and kindly advice formulae how to > remove certain words from sentence. > > > > Best Regards, > > Mehtab > > > > -

$$Excel-Macros$$ Formulae for Removing Certain Word from Sentance

2013-08-31 Thread mehtab shaikh
Dear Experts, Please find enclosed example sheet and kindly advice formulae how to remove certain words from sentence. Best Regards, Mehtab -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https:/

Re: $$Excel-Macros$$ Amount conversion from number to word

2013-08-31 Thread ashish koul
also try these links http://support.microsoft.com/kb/213360 http://blog.contextures.com/archives/2009/03/24/convert-number-to-words-in-excel/ http://www.ozgrid.com/VBA/CurrencyToWords.htm http://www.ozgrid.com/VBA/ValueToWords.htm http://excelvbaandmacros.blogspot.in/2011/12/excel-convert-amount-in