How do I transfer data from drop list column to different workshe.

[txcvega]

I created a drop-down list to choose in my columns. I want to be able to
transfer data from that column to another worksheet when a specific option is
chosen from the drop-down list.
Example: the drop-down list includes HVRS, HIS, AS, WOL, and MFG options.
When the HVRS is chosen in the header drop-down list, I would like all data
from that column to be transfered to another worksheet under the HVRS column.
The same would go for each of the options in the drop-down list.

 

[Frank Kabel]

Hi
this would require VBA . Is this feasible for you?

 

[txcvega]

If you are referring to Visual Basic, then yes. How can I use this to do what
I need to do in Excel?