Need help on Excel & VBA

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

manukit

Thread Starter
Joined
Jan 1, 2013
Messages
12
Hello all,

Please suggest on this topic. I have attached one excel file, in that i have several columns. I need to know that in column branch as i enter TA/FR/CC i required a msgbox to popoup & state "required proper authorized permission from XYZ". The authorized persons name are mentioned in next tab of the excel workbook, from there i require to extract the name of the concerned person whenever that branch has entered.

Please suggest me is there any other ways of sorting this out.

Thanks in advance..\

:)
 

Attachments

Joined
Jun 29, 2012
Messages
518
I believe this might resolve your question. In cell G2 I entered
=INDEX('Authorized persons'!$B$5:$B$11,MATCH(F2,'Authorized persons'!$C$5:$C$11))
and then dragged the formula down to cells G3:G10
There is no Msgbox, which could get tedious, it just fille Person Concerned with data from the Authorized person Sheet.
Does this help?
 

manukit

Thread Starter
Joined
Jan 1, 2013
Messages
12
Hi, thanks for the reply.. yes that might be used. But, instead of that i needed a msgbox popping out & stating the comment, so that it will be very clear. I just need to reference some data from next sheet to curr. sheet.

Thanks in advance...
:)
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
How are you going to trigger this, just a message box with infro, but how does it get started?
I think you will need to explain a little more, further more I think macros will be required too.
 
Joined
Jun 29, 2012
Messages
518
Manukit -
I put your msgbox in as requested, and it triggers from the entry made in the Branch column, as you indicated.
The code is set for up to 20000 entries made in Column F. MyRange("F2:F20000")
Once the Branch is entered, the entry is converted to Upper Case, and the Index Match formula is put into the Concerned Person Column, beside the Target cell in Col F.
This provides the method of getting the answer from the Index Match.
You will see the Result in Col. G, momentarily, the Message Box appears stating that proper authorized permission is required. After the Message Box is closed, Col G is blanked out, removing the formula. I needed it put there to be able to get the results of the Index Match.
Hope this helps.
 

Attachments

Joined
Jun 29, 2012
Messages
518
Manukit? Any feedback on this? It is getting very out of date on my open To Do list and I am concerned if it still requires resolution.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top