Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

How do I use arrow button to scroll through.

I have a worksheet with two sheets.  "Profile" sheet pulls information from "dem" sheet.  On the "Profile" sheet, in cell E4, I want to use arrows to scroll through the information that is in column B on "dem" sheet.  Right now, we have to type the ID in cell E4, but we'd like to just scroll right through. profile012311.xlsx
0
ITRTMartin
Asked:
ITRTMartin
  • 4
  • 3
1 Solution
 
shahzadbuxCommented:
you have attached a password protected file, post again without the protection and make sure you remove any sensitive info!
0
 
ITRTMartinAuthor Commented:
Thanks, I removed the sensitive info, but forgot the password!
profile012311.xlsx
0
 
shahzadbuxCommented:
Have a look at the attached file, it will show the names in a drop down list and expand and contract as you add to the list.

Data Validation on the cell E4 (Profile) and a dynamic named range
profile012311--1-.xlsx
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
ITRTMartinAuthor Commented:
I like that!  How do I replicate that on the "real" sheet?
0
 
shahzadbuxCommented:
Create a named range - Formula tab, name manager, new...

The one i created is called PowhatanID and in the formula box i entered =OFFSET(dem!$B$12,0,0,COUNT(dem!$B:$B),1)

This is a dynamic range, meaning it will get bigger as you add more info on the dim sheet

Next, go to the profile sheet and select the cell where you want the drop down (E4)

Add Data Validation - Data Tab, Data Validation..

Select list and in the formula box enter '=PowhatanID'

This tells it to use a list and get the information for the list from the named range we created before
0
 
ITRTMartinAuthor Commented:
Thank you!
0
 
shahzadbuxCommented:
No problems, have a look here for more options for dynamic ranges - http://www.ozgrid.com/Excel/DynamicRanges.htm
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now