Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to set up a routing that that will give the user of the template
an option as to who they want to send it to based on what area they live in. So my question is, can you set up a routing slip that will pop up an option as to who to send it to? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Column B input your cities. In Column C input your Contacts. Use Cell A1
for user input cell. In Cell A2 enter the following formula: =VLOOKUP(A1,B1:C20,2) "Marcus" wrote: I am trying to set up a routing that that will give the user of the template an option as to who they want to send it to based on what area they live in. So my question is, can you set up a routing slip that will pop up an option as to who to send it to? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How does that help a routing slip?
"Mike Campbell" wrote: In Column B input your cities. In Column C input your Contacts. Use Cell A1 for user input cell. In Cell A2 enter the following formula: =VLOOKUP(A1,B1:C20,2) "Marcus" wrote: I am trying to set up a routing that that will give the user of the template an option as to who they want to send it to based on what area they live in. So my question is, can you set up a routing slip that will pop up an option as to who to send it to? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Routing Slip | Excel Discussion (Misc queries) | |||
How do I use the routing feature for multiple senders | Excel Discussion (Misc queries) | |||
Prompt user to create routing slip | Excel Worksheet Functions | |||
How dynamically create routing slip based on names in specific cel | Excel Discussion (Misc queries) | |||
Can the default routing slip instruction be changed? | Excel Discussion (Misc queries) |