Relocate Combo Box Results

[sgoodlief]

Excel Forum Example.xlsx

Good day everyone!

I've been stuck on this problem for two days now and am in serious need of help!

My office wants to me to create a spreadsheet to keep track of our computer system files that need updated, combined, moved or deleted. On sheet1, I've created a simple table that will be the "action" page...I want the other sheets to display results from the data on sheet1.

So on sheet1 I've made multiple combo boxes where users can choose what they want to do with each file from a drop down menu. As an example, someone might choose:

File Name [Update]
File Name [Delete]
File Name [Update]
File Name [Move]

[] indicatng the combo box selection

What I'm trying to do:

I want all the files (File Names) that have been selected for Update to appear on sheet2, for Delete on sheet3, for Move on sheet4 (etc.). Do I need to use a function? Do I need to use code (which I don't know)?

PLEASE HELP!!!!!!!!!!!! I'm desperate:-(

[sgoodlief]

Can anyone help me???

[Tony Valko]

It would be easier to do if you used data validation drop down lists instead of combo boxes.

I think this can be done with formulas as long as you don't have 10s of 1000s of rows of data.

[sgoodlief]

Hey, thanks Tony! I appreciate it!

[sgoodlief]

Okay, I've changed all the combo boxes to drop down lists...but still don't know what function to use to display all of a particular selection on a seperate worksheet...

Any takers?

[Tony Valko]

This is the technique that you want to use:

http://www.excelforum.com/excel-form...ell-value.html

See if you can adapt it to your application.