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

Re: $$Excel-Macros$$ Macro Require

2013-07-01 Thread vikas khen
...@gmail.com Subject: Re: $$Excel-Macros$$ Macro Require To: excel-macros@googlegroups.com Date: Thursday, June 27, 2013, 7:09 PM why need macro ?try pivot table please find attached file . Enjoy Team XLS On Thu, Jun 27, 2013 at 6:30 PM, vikas khen vikk

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

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 vikk...@gmail.com wrote: Dear All, Please find the excel sheet. I need macro for the same Regards -- Are you =EXP(E:RT) or

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

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

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 aamirshahza...@gmail.comwrote: Dear Group, How to get the sheet names in one sheet? sample file is attached. Regards, Aamir Shahzad

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 aamirshahza...@gmail.comwrote: