Choose selective data from a range , driven from a drop down list?

**footsoldier** · 08-23-2013, 10:35 AM

I have a spreadsheet listing various pieces of computer hardware, software and mobile accessories, etc with costs attached.

I have created a dropdown list of staff profiles eg a sales representative, finance assistant, IT administrator.

What I want to do is get Excel to pull the data through from the data sheet, to a printable summary output form (something you could also cut and paste from). For example, a sale rep would need to be set up with a laptop, laptop case, mobile phone, etc, so when you select Sales rep from droplist, I want that action to pull all the associated data through to the summary form. Similarly, a Finance assistant would require different kit , perhaps a desktop PC , monitor , etc.

Next to my data I have created columns with "Y" for yes in cells containing kit that match the staff role requirements, but i am not sure of the best way to pull this together.

Any suggestions or help would be most welcome.

**newdoverman** · 08-23-2013, 10:57 AM

A copy of your workbook would be helpful.

**MarvinP** · 08-23-2013, 10:58 AM

Hi footsoldier and welcome from someone who has owned your name in too many jobs.

Find the attached that uses an Advanced Filter and Event Macros to filter your data like I think you want. This is one of many ways to do this problem. Having an example of what you have is always easier than trying to create a sample ourselves. See if this does what you are needing. Start learning Excel and you won't be a footsoldier for long.