Modify to suit
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Puttu *
Sent: Saturday, July 21, 2012 8:45 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Required Prefix Macro for the numbers
Hi Experts,
Please help on below macro need a macro to p
Thanks Don, but i need a macro for this, because i have too many sheets in
the same format. Macro will help me a lot to save my time
On Sat, Jul 21, 2012 at 9:53 PM, dguillett1 wrote:
> Modify to suit
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Required Prefix Macro for the numbers
Thanks Don, but i need a macro for this, because i have too many sheets in the
same format. Macro will help me a lot to save my time
On Sat, Jul 21, 2012 at 9:53 PM, dguillett1 wrote:
Modify to suit
Don Guillett
Please help me on this experts
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * wrote:
> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
>
> *Number* *
Any update on the below help?
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * wrote:
> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
>
> *Number* *Ou
Experts please help me on this code.
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * wrote:
> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
>
> *Num
Hi,
Kindly find the attached solutions.
Regards
Amresh
On Mon, Jul 23, 2012 at 12:40 PM, Puttu * wrote:
> Experts please help me on this code.
>
> On Sat, Jul 21, 2012 at 7:15 PM, Puttu * wrote:
>
>> Hi Experts,
>>
>> Please help on below macro need a macro to prefix on the below numbers. I
>>
Thanks Amresh, I need to run this multiple sheets, can i have this in
macro. Which is going to help me a lot.
Appreciate your help
On Mon, Jul 23, 2012 at 1:10 PM, Amresh Maurya wrote:
> Hi,
> Kindly find the attached solutions.
>
> Regards
> Amresh
>
>
> On Mon, Jul 23, 2012 at 12:40 PM, Puttu
Hi ,
I have attached a function for you kindly add it in your add-ins and use.
Function perfix(Outlet As String, Level As String, numbner As Integer)
If Outlet = "FOOD" And Level = "REGION" Then
perfix = "00200" & numbner
End If
If Outlet = "DRUG" And Level = "REGION" Then
perfix = "02200"
Dear Amresh kushwaha
U can use vlooup is these
=VLOOKUP(B8,H3:J8,3,0)&A8
On Mon, Jul 23, 2012 at 1:52 PM, Amresh Maurya <> wrote:
> Hi ,
>
> I have attached a function for you kindly add it in your add-ins and use.
>
> Function perfix(Outlet As String, Level As String, numbner As Integer)
>
> If
Thanks Amresh,
I think this serve my purpose, but need one more thing, since are vary one
cell have 2 digits no. and one have 3 digit numbers and one have 4 digit
numbers in the cell, finally it should be ending with 8 digit no. Is there
any way to put in code?
On Mon, Jul 23, 2012 at 1:52 PM, A
This is how the output I am looking for each creteria. with the VBA code
If len is 3 and outlet is FOOD and Level is REGION then it should reflect
as 00200100
if len is 2 and outlet is FOOD and Level is REGION then it should reflect
as 00200010
If len is 4 and outlet is FOOD and Level is REGION th
Thanks Amresh, This is what i was looking. Appreciate your timely help.
Thanks again a lot :)
On Mon, Jul 23, 2012 at 3:06 PM, Amresh Maurya wrote:
> Hi ,
>
> find the attached file.
>
> use this code.
>
> Function perfix(Outlet As String, Level As String, numbner As Integer)
>
> If Outlet = "FO
eveloper
SalesAid Software
dguille...@gmail.com
From: Amresh Maurya
Sent: Monday, July 23, 2012 4:36 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Required Prefix Macro for the numbers
Hi ,
find the attached file.
use this code.
Function perfix(Outlet As String, Lev
c
Case "FOOD" & "MKT": c.Offset(, 5) = "00300" & c
Case "drug" & "region": c.Offset(, 5) = "02200" & c
Case Else
End Select
Next
End Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Pu
15 matches
Mail list logo