$$Excel-Macros$$ required help for attached file

2016-12-02 Thread jitendra kumar
Hi Team, Please help in this attached file format. *Regards,* *Jitendra Yadav + 91 9650449202* -- 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

$$Excel-Macros$$ Required help for count of present days

2015-10-01 Thread Jitendra Kumar
Dear All, Please help for count of available manpower for A,B & C company. Regards, Jitendra Kumar +91-9650449202 -- 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 @ h

Re: $$Excel-Macros$$ How to get most used number in the cell using formula

2014-07-07 Thread jitendra kumar
Hi All, if any where requirement in MIS Please update me. Regards/Jitendra 9650-449-202/0124 3992-888 -- 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

$$Excel-Macros$$ Delete all defined workbokk names

2010-09-24 Thread Jitendra Kumar Verma
Hi All, I have 3+ defined names in workbook and want to delete it. I have written code below, Dim nm as name For each nm in activeworkbook.names Nm.delete Next But it takes too much time to delete. Is there any other way to faster delete the all defined names from workboo

$$Excel-Macros$$ Any Opening for the Excel VBA Developer

2010-06-02 Thread Jitendra Kumar Verma
Hi Groups, Any Opening for the Excel VBA Sr. Developer in Delhi NCR. I want to change. Thanks Jitendra Kr. Verma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

RE: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired

2010-06-01 Thread Jitendra Kumar Verma
Use this macro to Rename the sheet. Sub Renamesheet() Dim shtName As String For Each sht In ThisWorkbook.Sheets shtName = sht.Name shtName = Left(shtName, 2) & Replace(shtName, "05", "06", 3) sht.Name = shtName Next End Sub Regards, Jiten

$$Excel-Macros$$ Re: { } -his is a function?

2009-05-01 Thread Jitendra Kumar
BUT... someone else has used {=DfListHolidays > ("USA","2005","2010")} in a column. and cells in that column show all > banking holidays from 2005 to 2010. > > My question is what is { } ? How does it work? > > I have upload the file called "Kalen

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

2009-04-27 Thread Jitendra Kumar
Dear Ashish, Is there any version which is compatible with Excel 2003 as i am using Excel 2003. Best Regards, Jitendra Kumar On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > If you want to do any or all of the following. Visit > http://www.excel

$$Excel-Macros$$ Re: Need Help regarding split Emp. Name & Emp. ID

2009-04-13 Thread Jitendra Kumar
Dear Lavprasad, Please see the attached file with the solution of your problem. Hope that helps. Thanks & Regards, Jitendra Kumar On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote: > > Dear Friends, > > I am downloading the employee data from our portal. In, there is emplo