98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation, Index Function or both
Data Validation, Index Function or both
Resolved · Urgent Priority · Version 2003
Alu has attended:
No courses
Data Validation, Index Function or both
Hi
I have created a spreadsheet called "Job Tracker" holding information such as job no, contact name, address, etc.
What I want now is to create a Front Cover Summary Page which when I put a unique job ref in from a dropdown list e.g. EPS1234 all the information relating to that job ref from the "Job Tracker" worksheet will be displayed in a summary page.
I have been muddling on with this and not sure whether should be using data validation or index function.
The job no list is continually added to so the list will need to incorporate this. I know how to use data validation if the data is being picked up in the same worksheet but not when pulling information from another.
Then I thought if I can get this validation rule working I can use Index function to pull all the related information through from the "Job Tracker" worksheet once a job ref was selected from the drop down list. However, not 100% on how to use Index function either.
Can anyone help please?
RE: Data Validation, Index Function or both
Hello Alu
Thank you for your question.
This is not a scenario that we can offer a 'quick fix' for.
It would involve dedicated time with one of our trainers to help you resolve in a training/consultative role, which would be billable.
Alternatively we do offer a 2 day Excel VBA course on our public schedule in London, which would cover the basics of using VBA to manipulate data in Excel (which you could then apply to resolve the scenario you describe here).
If you are interested in either of these options, please contact our enquiries team (or e-mail info@stl-training.co.uk)
Kind regards
Amanda
Training information:
- Microsoft excel training day courses near kent
- Microsoft+excel+training
- Microsoft Excel Training London
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding columns using the keyboardCTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal |