data validation index function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation, Index Function or both

Data Validation, Index Function or both

resolvedResolved · 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


 

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips


Server loaded in 0.08 secs.