I have a list of list of data that has a column with duplicates.  I have sorted all of my duplicates together abc by number.  These two duplicates have also been color coded, one record is red and other is green.  I have put my red record on top.  However, I want to use a piece of the green data to fill in a cell on the red data.  For example

       A                   B                     C                     D

1    FILE 1           325                  BOOKS             (I WANT TO COPY C2 HERE)

2   FILE 2            325                 BOOKS  - ALL     (I WANT TO LEAVE A BLANK HERE)

I have attempted to drag autofill throughtout column D, since all of my records are duplicates (i.e. column B, have same number); however they have similiar but yet different descriptions -- column C.  I want to put the once that has the more descriptive description in the first cell (D1) and leave the next cell blank.  However, this worked in 2003, when I selected D1 and kept d2 blank and used the fill handler, which went ahead and copied all of the cells in the proceeding positions...but doing it in 2007...it doesn't.  It only copies cell by cell, versus cell, skip, and next cell. 

Again, this is due by Monday...If I need to, I can send example.

Also, please know that I've tried going in and reformatting the fill-handle -- doing excel options button...edit custom list...but not sure what to do from there...

Any help is appreated.

Thanks,
April

aprildcq38@gmail.com