$$Excel-Macros$$ Fwd: FW:

Team, I have two excel file attached here which are password protected .but i have forget the password . kindly support me and any one help me to open this file . thanks regards Gaurav -- Forwarded message -- From: GAURAV Jayendra (CNH Industrial) Date: Mon, Aug 11, 2014 at 2

Re: $$Excel-Macros$$ Re: VBA questions

Hi Kapil, Please find the Answer for your VBA Q... One Q has been left.you can take ans from do google.. Regards Pramod On Tue, Aug 12, 2014 at 12:27 AM, kapil Gupta wrote: > Please solve this question is very urgent. > > On Sunday, August 3, 2014 11:51:07 PM UTC+5:30, kapil Gupta

$$Excel-Macros$$ Re: VBA questions

Please solve this question is very urgent. On Sunday, August 3, 2014 11:51:07 PM UTC+5:30, kapil Gupta wrote: > > Hello, > > Please solve this VBA Question paper As soon as possible. Please > find the attached files and check. > > > Regards, > Kapil Gupta > -- Are you =EXP(E:RT) or =NOT(E

Re: $$Excel-Macros$$ Please solve this sheet its very urgent

Thanks you really genius. Regards, Kapil Gupta On Monday, August 11, 2014 3:57:39 PM UTC+5:30, Vabz wrote: > > Hi > > FA > > Cheers!! > > > On Mon, Aug 11, 2014 at 1:03 PM, kapil Gupta > wrote: > >> Hello, >> >> Please sheet and question mention in under of sheets. >> >> >> Regards, >> Ka

Re: $$Excel-Macros$$ Help to skip saturday sunday and holidays while substracting the number of days from date.

Hi Check this http://www.keynotesupport.com/excel-functions/networkdays-function.shtml Cheers!! On Mon, Aug 11, 2014 at 6:03 PM, pankaj khairanar wrote: > Dear Experts, > > Hope you are doing well! > > I want Required your help in below scenario. > > Actually I want to substract number of da

Re: $$Excel-Macros$$ On time Issue

see this att for ref. Cheers!! On Mon, Aug 11, 2014 at 8:09 PM, Vaibhav Joshi wrote: > Hi > > In first code add at the end this line.. > > Call Ontime_PivotRefresh > > > Cheers!! > > > On Mon, Aug 11, 2014 at 7:48 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hi, >> >> am tr

Re: $$Excel-Macros$$ On time Issue

Hi In first code add at the end this line.. Call Ontime_PivotRefresh Cheers!! On Mon, Aug 11, 2014 at 7:48 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > am trying to refresh pivot every one minute but its running first time and > its not enter there after may I know wha

$$Excel-Macros$$ On time Issue

Hi, am trying to refresh pivot every one minute but its running first time and its not enter there after may I know what is problem in the code. Thanks in advance. Sub PivotsRefresh() Dim sh As Worksheet Dim pt As PivotTable MsgBox "Enter..." For Each sh In ActiveWorkbook.Sheets 'sh1 = sh.Na

Re: $$Excel-Macros$$ Filter on name in all sheet than paste in Master sheet

Hi, Use this ?? Sub Collect_Data1() Dim fld As Folder Dim fl As File Dim k As Long Dim wkb As Workbook Dim i As Long Dim fso As New FileSystemObject Set fld = fso.GetFolder("C:\Users\satendra.kumar\Downloads\New folder\New folder") With Application .DisplayAlerts = False .Calculation =

$$Excel-Macros$$ Help to skip saturday sunday and holidays while substracting the number of days from date.

Dear Experts, Hope you are doing well! I want Required your help in below scenario. Actually I want to substract number of days from the date but I want to skip holidays, saturday and sunday means I want to only substract the buisness day from date. For example.. Req Date is- 11 Aug 201

Re: $$Excel-Macros$$ Help for date formula

Hi Use datedif formula: =DATEDIF(A1,A2,"m") where a1 contains oldest date. Cheers!! On Mon, Aug 11, 2014 at 3:54 PM, Shrinivas Shevde wrote: > I wish to find out difference between two dates in terms of Months. > > > > e.g. 10th May 2014 & today = 3 months > > 10th May 1993 & today = 255 mo

Re: $$Excel-Macros$$ Help for date formula

Hi Srinivas, PFA...!! Regards Ashish On 11 August 2014 15:54, Shrinivas Shevde wrote: > I wish to find out difference between two dates in terms of Months. > > > > e.g. 10th May 2014 & today = 3 months > > 10th May 1993 & today = 255 months > > 10th jan 1981 & today = 403 months > > > --

Re: $$Excel-Macros$$ Please solve this sheet its very urgent

Hi FA Cheers!! On Mon, Aug 11, 2014 at 1:03 PM, kapil Gupta wrote: > Hello, > > Please sheet and question mention in under of sheets. > > > Regards, > Kapil Gupta > > -- > 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 Fac

$$Excel-Macros$$ Help for date formula

I wish to find out difference between two dates in terms of Months. e.g. 10th May 2014 & today = 3 months 10th May 1993 & today = 255 months 10th jan 1981 & today = 403 months -- Shrini -- 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) ! Joi

Re: $$Excel-Macros$$ Excel Macros Help

THANK YOU so much for your time & efforts. Regards venkat On Thursday, August 7, 2014 6:29:25 PM UTC+5:30, Vabz wrote: > > hi > > check this., as soon as any data is changed you will get notification to > update it.. > > Cheers!! > > On Mon, Aug 4, 2014 at 3:40 PM, venkateswara reddy > wrote:

$$Excel-Macros$$ Please solve this sheet its very urgent

Hello, Please sheet and question mention in under of sheets. Regards, Kapil Gupta -- 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://www.facebook.com/discussexcel FORUM RULES 1) Use co