Hi Brian

click on column D choose edit / goto - then click the SPECIAL BUTTON
choose CONSTANTS then click OK
now copy & paste the information as normal and the blank spaces will not be
brought over.

Cheers
JulieD

"Brian" wrote in message
...
My worksheet (worksheet1)has data in cells a1:H50. Column D has some blank
cells and data in other cells. In worksheet 2, I would like to list in
column
A, all of the values in worksheet1- (D1:D50) but with no blank cells in
the
list. Thanks for help with this formula.