It’s easy enough to use a macro to apply the vlookup formula, assuming you have
the table set up or you could use a SELECTCASE macro.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Puttu *
Sent: Saturday, July 21, 2012 11:53 AM
To: excel-macros@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 <dguille...@gmail.com> wrote:
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 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 Outlet Level Code should some thing like this This is how I am
looking for output
100 FOOD REGION If Outlet is "Food" & Level is "Region, then Number
should prefix 00200 00200100
150 DRUG REGION If Outlet is "DRUG" & Level is "Region, then Number
should prefix 02200 02200150
9999 MASS TOTUS If Outlet is "MASS" & Level is "TOTUS, then Number
should prefix 0010 00109999
300 CLUB CUSTM If Outlet is "CLUB" & Level is "CUSTM, then Number
should prefix 01650 01650300
14 FOOD MKT If Outlet is "FOOD" & Level is "MKT, then Number should
prefix 003000 00300014
400 LIQ CUSTM If Outlet is "LIQ" & Level is "CUSTM, then Number should
prefix 008100 08150400
--
Putta
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
mailto:excel-macros%2bunsubscr...@googlegroups.com
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
mailto:excel-macros%2bunsubscr...@googlegroups.com
--
Putta
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
