LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Using list or macros to input predetermined values

Hi, I'm not too familiar with the use of macros, and I'm not sure I need to
use them in this case. However, I am looking to essentially create a single
list that inputs values across a range of cells (across columns). For
example, consider a table of values:

A 1 13
B 5 10
C 2 7

I would like to create a spreadsheet containing a cell with a list, where I
can select the row A,B or C - and the adjacent values will automatically be
entered. (ie. select B from a list, and 5 10 appear (calling from a
preconstructed table).

I'm sure there are a number of ways, which is the simplest? Cheers.
 
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
How to restrict input to a list of values - with a twist Rod Excel Worksheet Functions 7 January 5th 09 05:26 AM
How do I highlight numbers above or below predetermined values? Kurt Excel Discussion (Misc queries) 5 September 26th 08 03:36 PM
Averaging values from a list, based on user input MWS Excel Worksheet Functions 3 June 5th 07 06:47 PM
Finding a predetermined Sum from a List of Numbers [email protected] Excel Discussion (Misc queries) 5 January 17th 07 12:11 AM
Check a user-input value against a list of values? Bill_S Excel Programming 1 April 28th 05 03:24 AM


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

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

About Us

"It's about Microsoft Excel"