Hello,

I want some data from another sheet to automatically populate in a new
sheet.

The sheet holding the data is in A19:I150 and it has the heading is
the following:

Date Desc Code No Dep Disb Balance
GL Cleared
Balance
100,000.00
1/1/10 ABC zxcv 10-01 -1500
98,500.00 Y N
1/2/10 CVB werv 10-02 -78.69
98,421.31 Y N
1/5/10 CVB zxcv 10-08 -10.00
98,411.31 N Y
1/6/10 PPP werc 1023 -5.00
98,406.31 N Y

I would like the records marked "N" from the "Cleared" column to
populate in a new sheet and display only the following information
Date Desc No Disb

Based on data provided in this example, it should populate
1/1/10 ABC 10-01 -1500
1/2/10 CVB 10-02 -78.69

Please help me,
Thanks