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
