Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referenceing worksheets in excell 2003
I need a way for values in sheet 1 B17 thru B23 to be input into sheet 2 H3
and the answers to be shown in sheet1 C17 thru C23 based upon a list choice on sheet 1 F11. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referenceing worksheets in excell 2003
A little more information please. What's going on here - some time of
examination answer checking application or what. In saying "I need a way for values in sheet 1 B17 thru B23 to be inut into sheet 2 H3 " what exactly do you mean. As in any individual value from sheet1 B17 through B23 could be entered? If that's the case there is a way to give the B17:B23 range on Sheet1 a name and then use Data Validation in Sheet2 H3 referencing that list as available choices. That would take care of that part of things. Finally, where do the "answers" that are to be shown in Sheet1 C17:C23 coming from? "At a loss" wrote: I need a way for values in sheet 1 B17 thru B23 to be input into sheet 2 H3 and the answers to be shown in sheet1 C17 thru C23 based upon a list choice on sheet 1 F11. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why Can't I navigate Excell 2003 Worksheets via Navigation Bar | Excel Worksheet Functions | |||
Excell worksheets | Excel Worksheet Functions | |||
indirect function referenceing changing file name | Excel Worksheet Functions | |||
cross referenceing data in excel | Excel Discussion (Misc queries) | |||
Excel 2003 - referenceing the active worksheet page in vlookup | Excel Worksheet Functions |