using list

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I'm using a list in one cell that reference another work sheet where the data
is. When I use the drop down list it return a number in my work sheet. from
cell A1. I also want to return a number in B1 to a different cell in my work
sheet at the same time. I hope I explained this right.
 
You're a little short on details.

Assume you are using a Data Validation dropdown list for selecting a value.

Which cell is the list in?

'It return a number in my work sheet from A1"

How does it do that and to where is it returned?

If you know how, you should be able to set up "a different cell" in the same
manner.

Post some details and cell references.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Reference a fixed cell on different sheets 4
Code to format cells on several worksheets 2
How to Link drop-down list? 2
Drop Down Lists 3
Excel 07 fill in cells based on what is selecte in another cell 1
To Link drop-down list 1
Combo Box dropdown data 20
How to Display 12.5 but not 25.0 (drop .0’s) 5

Back
Top