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?

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?