Re: $$Excel-Macros$$ Macro Require

2016-03-06 Thread jayendra gaurav
please support me. On Mon, Feb 29, 2016 at 6:19 PM, jayendra gaurav wrote: > Dear All, > > > I have 1150 separate files of part list Variant wise. and other hand I > have part list can you please suggest way that how can I search part usage > quantity of each part no as per variant wise. > > *Ex

Re: $$Excel-Macros$$ Macro Require

2013-06-30 Thread vikas khen
Hi Team XLS / Ravinder, Thank you so much for given me the solution. you people are genius. *Regards* On Fri, Jun 28, 2013 at 1:11 PM, ravinder negi wrote: > Hi, PFA for you solution.. > > --- On *Thu, 6/27/13, xlstime * wrote: > > > From: xlstime > Subject: Re: $

Re: $$Excel-Macros$$ Macro Require

2013-06-27 Thread xlstime
why need macro ?try pivot table please find attached file . Enjoy Team XLS On Thu, Jun 27, 2013 at 6:30 PM, vikas khen wrote: > > Dear All, > > > Please find the excel sheet. I need macro for the same > > > > Regards > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Macro Require

2013-06-27 Thread vikas khen
Dear All, Please find the excel sheet. I need macro for the same Regards -- 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 concise, accura

Re: $$Excel-Macros$$ Macro Require.

2013-06-19 Thread De Premor
i've attached 2 method, 1st using UDF, 2nd using Excel Formula, try it Rgds, [dp] Pada 19/06/2013 18:34, Prafull Jadhav menulis: Dear All, find the excel sheeti need macro for the same Regards, Prafull -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TI

$$Excel-Macros$$ Macro Require.

2013-06-19 Thread Prafull Jadhav
Dear All, find the excel sheeti need macro for the same Regards, Prafull -- 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 concise,

Re: $$Excel-Macros$$ Macro require

2013-01-30 Thread NOORAIN ANSARI
Dear Aamir, Pls try *Sub Extract_SheetName() Dim sh As Worksheet Dim i As Integer i = 1 For Each sh In ThisWorkbook.Sheets If sh.Index <> 1 Then Sheet1.Cells(i, 1).Value = sh.Name i = i + 1 End If Next sh End Sub * On Wed, Jan 30, 2013 at 8:20 PM, Aamir Shahzad wrote: > Dear Group, > > How to

Re: $$Excel-Macros$$ Macro require

2013-01-30 Thread ashish koul
Sub tes() Dim i As Long For i = 2 To Sheets.Count Sheets(1).Cells(i - 1, 1) = Sheets(i).Name Next End Sub On Wed, Jan 30, 2013 at 8:20 PM, Aamir Shahzad wrote: > Dear Group, > > How to get the sheet names in one sheet? sample file is attached. > Regards, > Aamir Shahzad > > -- > Join offici

$$Excel-Macros$$ Macro require

2013-01-30 Thread Aamir Shahzad
Dear Group, How to get the sheet names in one sheet? sample file is attached. Regards, Aamir Shahzad -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Hel