You could apply an Autofilter to your data. In column A, click on the
dropdown box and choose "Blanks", then copy the visible rows to your
new sheet.

Check it out here http://www.rondebruin.nl/copy5.htm


HTH,
JP

On Nov 15, 7:00 am, Terry wrote:
This is what im trying to do, I have the data sorted I just need to pasted to
a summary sheet.

If a Cell in Column A is Blank Paste Cell J From the same row to make a
summary page.

ie Date
A J
1 500
2 500
3 500
4 500
Blank (500) Paste this one
6 600
Blank (600) Paste this one
8 700

ie Summary
500
600
ect..