Conditionally Add Data to another worksheet

[Memana]

Dear All,
I want to add currently selected row to another Worksheet depends
upon the value selected using a cmbobox in that Row.

For example, Suppose i have an xls file with 3 Worksheets. The name
of the 3 work sheets are "All" "New" & "Old".

All the rows in the "All" named worksheet contains a combobox
selection cell, and the values in the combo box are "New" & "Old". If
I select "New" value from the combo box, then that row should be added
to the "New" named Worksheet. If I select the "Old" value from the
combo box, then that row should be added to "Old" Worksheet. Please
tell me how can I do that.

Thanks in advance,
Mem.