LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 86
Default Please help. Need drop down menu for name&price to pop up automat

In spreadsheet Book 2

Column A Column B Column C Column D Column E
Column F
Name Rates Address City
Zip Code
Jane Doe 76.76 555 North Dear Born Chicago 55555
IL
Ray Cohen 12.11 2 North Dear Born Chicago 1
NY

In book 3 I want drop down menus for columns A, C, D, E,F from the info of
book 2.
When I choose the name in column A in book 3 i want the rates to pop
automaically.
Ex when I choose Jane Doe i want her rate to pop automaically as 76.76.



 
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
Drop down menu along with price CYNTHIA Excel Discussion (Misc queries) 3 August 23rd 07 10:50 PM
choose a product from a drop down list i need it to insert a price Barnzy Excel Worksheet Functions 6 April 12th 07 04:48 PM
Return a price based on a customer from a drop down list Pete Elbert Excel Discussion (Misc queries) 7 May 1st 06 02:54 AM
Cross-referenced drop-down menu (nested drop-downs?) creativeops Excel Worksheet Functions 4 November 22nd 05 05:41 PM
In MS Excel, after you input an USD amount, an option for automat. Mohamed S. Excel Worksheet Functions 6 February 1st 05 06:09 AM


All times are GMT +1. The time now is 03:12 PM.

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"