On Jul 14, 9:38*pm, Dave Peterson wrote:
I never like deleting data <bg. *It's usually too difficult to get back if/when
you need it.

But if the original poster wants to fill those cells with the values from above
(for any reason), Debra Dalgleish shares how to do that, too:

http://contextures.com/xlDataEntry02.html
and here (as a video):http://www.contextures.com/xlVideos01.html#FillBlanks

On 07/14/2010 12:39, Ron Rosenfeld wrote:

On Wed, 14 Jul 2010 12:30:20 -0500, Dave Peterson
*wrote:

I wouldn't do this.

It may screw up any sorts/filters/charts that you decide you want to use in the
future.

Instead, I'd leave the duplicated values, but hide them using conditional
formatting.

I see you had the same idea I did. *Yours was posted first but I
didn't see it until after I had posted mine.

--
Dave Peterson

Thanks Dave and Ron for your excellent imput as always and i will have
a look at Debra Dalgleish's examples and it may be necessary to keep
the data after thinking about it.

Many thanks for all the help
Eddie