Hi,

I have got Excel worksheets A and B. Sheet A is the master sheet. A
has got records (rows) containing information about employees such as
id, name, address, department, salary and processed. Processed field
has a value "Yes" or "No". I have a command button in A which when
clicked I want all the rows with processed field = "No" to be copied
to B.

Also I want the department cell, in each row, in B to behave like a
list box. It should contain all distinct department names from A. It
should allow me to select one of them. I hope I have been clear with
the question.

Please can someone help me with some example code.
Thanks