How to get a list from one worksheet to another.

  • Thread starter Thread starter RJ Swain
  • Start date Start date
R

RJ Swain

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
 
Back
Top