Referenceing worksheets in excell 2003

  • Thread starter Thread starter At a loss
  • Start date Start date
A

At a loss

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?
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use a Range in a Loop 2
Concatenate problem 7
making a portion of reference to a worksheet variable in a formula 1
Code to format cells on several worksheets 2
How to get an Excel function to recognise text 1
worksheet renames - specific 0
last entry in a range? 2
Working with MAX and IF 2

Back
Top