How to get a list from one worksheet to another.
 

Good Afternoon and Thank you!

I am currently working on a spreadsheet with 2 different worksheets. One
worksheet "Deposit Calculations" I have a list of branches that I would like
to carry over to the 2nd worksheet "What If Scenario" but be able to select
just one from the list from "Deposit Calculations"
example:

Deposit Calculations worksheet (A3 thru A21) lists the branches I want to
provide to the users to select their branch from.

What If Scenario worksheet (A3) would have a list of the branches for the
users to select from.

Also, is there a formula you can use to pull information from the 1st based
on the users selection on the 2nd sheet?

Thank you

How to get a list from one worksheet to another.
 

Visit Debra Dalgleish's site for info on Data Validation selection lists.

http://www.contextures.on.ca/xlDataVal01.html

Also see Debra's info on VLOOKUP function to pull data based on the selection
from the DV list.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Sat, 16 Feb 2008 12:45:01 -0800, RJ Swain
wrote:

Good Afternoon and Thank you!

I am currently working on a spreadsheet with 2 different worksheets. One
worksheet "Deposit Calculations" I have a list of branches that I would like
to carry over to the 2nd worksheet "What If Scenario" but be able to select
just one from the list from "Deposit Calculations"
example:

Deposit Calculations worksheet (A3 thru A21) lists the branches I want to
provide to the users to select their branch from.

What If Scenario worksheet (A3) would have a list of the branches for the
users to select from.

Also, is there a formula you can use to pull information from the 1st based
on the users selection on the 2nd sheet?

Thank you