Vlookup or IF function ?

[Guest]

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..

 

[JP]

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

 

[Guest]

Thanks JP this works for one part of what I am doing. One problem is when I
filter the sums of each amount disappears.
Is there a way i can filter a column to show only formulas spefically
(=subtotal)