Re: $$Excel-Macros$$ powerpoint interactive dashboard (scrollbar) code for anyone (my gift)

2015-06-28 Thread Priyanka Sachdeva
Thanks a lot of this ! On Wed, Jun 17, 2015 at 1:48 AM, Pascal Baro wrote: > enjoy > > Option Explicit > > Private Sub ScrollBar2_Change() > > Dim myChart As Chart > Dim gChartData As ChartData > Dim gWorkBook As Excel.Workbook > Dim gWorkSheet As Excel.Worksheet > > Set myChart = ActivePresenta

Re: $$Excel-Macros$$ Crack Password on MS Excel Template

2014-10-11 Thread Priyanka Sachdeva
Dangerous Proposition discussing on how to crack passwords for VBA Coding. Guess its against the forums rules Regards, Priyanka S On Sat, Oct 11, 2014 at 3:47 PM, P.VIJAYKUMAR wrote: > Respected Theresita Kirriwom, > > *You can use Straxx Password Remover which is a free-addin(professional > ve

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

2014-03-27 Thread Priyanka Sachdeva
Thanks All ! .. It worked On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar wrote: > Hi Priyanka, > > PFA > > > Thanks > Ashish > > > On 23 March 2014 17:35, Priyanka Sachdeva > wrote: > >> Thanks Abhishek, >> >> Yes, I did see the formula. N

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

2014-03-23 Thread Priyanka Sachdeva
in correct format so as > Excel reads them as values to allow subtraction, it will work. I just used > simple subtraction and set the format show only minutes. See 'Format Cell' > tab on the result for more clarity. > > Regards, > Abhishek > > > On Sat, Ma

Re: $$Excel-Macros$$ Difference in minutes between 2 dates

2014-03-22 Thread Priyanka Sachdeva
clock (eg 10:29:00 PM instead of 22:29:00) Regards, Priyanka S On Sat, Mar 22, 2014 at 7:44 PM, Abhishek Jain wrote: > Please see attached. > > HTH > > > On Sat, Mar 22, 2014 at 7:16 PM, Priyanka Sachdeva < > priyanka.sachdeva...@gmail.com> wrote: > >> Hell

$$Excel-Macros$$ Difference in minutes between 2 dates

2014-03-22 Thread Priyanka Sachdeva
Hello All, Am looking to calculate the difference in minutes between 2 dates. ( Inception Date and Closure Date) Eg : Inception Date = 02-12-2014 10:26:12 (mm-dd-yyy hr:mm:ss) Closure Date = 02-12-2014 22:29:00 I need a formula to calculate the difference in minutes i between these 2

Re: $$Excel-Macros$$ 10 Quick Time-Saving Excel Shortcuts & Mouse Tricks

2013-12-15 Thread Priyanka Sachdeva
Quite handy this ! Thanks ! On Mon, Dec 9, 2013 at 8:20 PM, anoop kumar wrote: > > http://excelautomate.blogspot.in/2013/11/10-quick-time-saving-excel-shortcuts.html > > -- > 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

Re: $$Excel-Macros$$ Need a professional MIS Report.....

2013-12-15 Thread Priyanka Sachdeva
Indrajit, Try the below link http://chandoo.org/wp/excel-dashboards/ One of the better sites for Dashboard templates. Helped me put together something similar a couple of months back Regards, Priyanka S On Sat, Dec 14, 2013 at 10:32 PM, Indrajit $nai wrote: > Hi Experts, > > I have a repo

Re: $$Excel-Macros$$ Interactive Dashboards

2013-08-31 Thread Priyanka Sachdeva
excel-salary-survey-contest-results/ > http://www.facebook.com/EXCELVBAMACROS > > http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html > > > Regards > Ashish > > > > On Sat, Aug 31, 2013 at 8:14 PM, Priyanka Sachdeva < >

Re: $$Excel-Macros$$ Interactive Dashboards

2013-08-31 Thread Priyanka Sachdeva
ww.facebook.com/EXCELVBAMACROS > > http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html > > > Regards > Ashish > > > > On Sat, Aug 31, 2013 at 8:14 PM, Priyanka Sachdeva < > priyanka.s...@gmail.com > wrote: > >> Hello

$$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