Solved

How do I use arrow button to scroll through.

Posted on 2011-02-22
7
210 Views
Last Modified: 2012-05-11
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
Comment
Question by:ITRTMartin
  • 4
  • 3
7 Comments
 
LVL 10

Expert Comment

by:shahzadbux
ID: 34951952
you have attached a password protected file, post again without the protection and make sure you remove any sensitive info!
0
 

Author Comment

by:ITRTMartin
ID: 34952005
Thanks, I removed the sensitive info, but forgot the password!
profile012311.xlsx
0
 
LVL 10

Expert Comment

by:shahzadbux
ID: 34953263
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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:ITRTMartin
ID: 34953498
I like that!  How do I replicate that on the "real" sheet?
0
 
LVL 10

Accepted Solution

by:
shahzadbux earned 500 total points
ID: 34953568
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
 

Author Closing Comment

by:ITRTMartin
ID: 34953615
Thank you!
0
 
LVL 10

Expert Comment

by:shahzadbux
ID: 34953683
No problems, have a look here for more options for dynamic ranges - http://www.ozgrid.com/Excel/DynamicRanges.htm
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question