#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default Routing Slips

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Routing Slips

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 32
Default Routing Slips

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Routing Slip Andrew Excel Discussion (Misc queries) 1 October 24th 06 04:50 PM
How do I use the routing feature for multiple senders Gordon McDougall Excel Discussion (Misc queries) 0 December 19th 05 09:13 PM
Prompt user to create routing slip Kathy Excel Worksheet Functions 0 September 19th 05 03:56 PM
How dynamically create routing slip based on names in specific cel arich Excel Discussion (Misc queries) 1 August 25th 05 11:52 PM
Can the default routing slip instruction be changed? rgonzalez Excel Discussion (Misc queries) 0 April 18th 05 06:44 PM


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"