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
ITRTMartinAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
shahzadbuxConnect With a Mentor Commented:
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
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
ITRTMartinAuthor Commented:
I like that!  How do I replicate that on the "real" sheet?
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
All Courses

From novice to tech pro — start learning today.