-Original message-
From: Prajakt Pande
Sent: 23/02/2012, 10:30 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ search via macro like excel
Dear MARIES,
Thank you very much.
On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote:
> Hi Prajakt,
>
> Please find the
-Original message-
From: Prajakt Pande
Sent: 23/02/2012, 10:30 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ search via macro like excel
Dear MARIES,
Thank you very much.
On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote:
> Hi Prajakt,
>
> Please find the
-Original message-
From: Prajakt Pande
Sent: 23/02/2012, 10:30 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ search via macro like excel
Dear MARIES,
Thank you very much.
On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote:
> Hi Prajakt,
>
> Please find the
Dear MARIES,
Thank you very much.
On Tue, Feb 21, 2012 at 8:44 PM, Maries wrote:
> Hi Prajakt,
>
> Please find the attached file.I have used below codes in user form.
>
> Private Sub CommandButton1_Click()
>
> Dim rng1 As Range
> Dim lll As Integer
>
> Sheets("Sheet2").Select
> Cells.Se
>
> **
>
> 2012/2/21 Maries
> Hi Prajakt,
>
> Please find the attached file.I have used below codes in user form.
>
> Private Sub CommandButton1_Click()
>
> Dim rng1 As Range
> Dim lll As Integer
>
> Sheets("Sheet2").Select
> Cells.Select
> Selection.ClearContents
>
> lll = Len(Te
PFA.
*Formula - =INDEX(B2:B21,MATCH(TRUE,VALUE(RIGHT(A2:A21,4))=H12,0))*
On Sun, Feb 19, 2012 at 12:15 PM, Prajakt Pande wrote:
> Dear all,
>>
>> Roll on codes are maximum 8 digits, I want to search via roll on
>> codes, at least 4 digits,
>> Where ever it matches with sequence, need to update t
Dear all,
Roll on codes are maximum 8 digits, I want to search via roll on
codes, at least 4 digits,
Where ever it matches with sequence, need to update the other
information in respective field, with next and previous option,
If “Roll on code” is not available then search via NAME. Sheet
attached
