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