Interesting

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Select entire range then F5SpecialBlanksOK

Type an = sign in active blank cell then point to cell above and hit
CTRL +
ENTER.

CopyPaste Special(in place)ValuesOKEsc.


Gord Dibben Excel MVP

On Wed, 23 Nov 2005 06:46:37 -0600, shepshedlad
wrote:


sorry but the layout has altered in my last post: there are 3 columns,
1:Date 2:Customer 3:product

column 1 & 2 are empty when customer places more than one product.

Thanks
Rob