here's a thought:

Put this formula in B1: =A2

Copy B1: B2
Select cells down column B as far as you need
Press [Enter] to paste those formulas

Now you should have formulas in cells B1, B3, B5,...etc

Now, select the whole range
DataFilterAutoFilter
Click the dropdown on Col_B and select Non-blanks

Now, copy those visible cells
Select a blank worksheet
EditPaste SpecialValues

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=492171