Hi,

I have two range of values, the first one containing the detail of cheques
issued to parties and the second containing detail of cheques presented in
the bank by the parties. What I am doing now is moving the row from the
first range to second when any cheque is presented at the bank.

columns in the range a
A B C D E
date ch.no. name amount date presented in bank

what I want is when i put date in column in E move the entire row to the
second range.

can any body help with a forlulae or vb code

thanks