I'm hoping I can do this with functions but it may need to be a macro.
I've been looking at it for awhile now and can't work it out.
I have two columns. Column A has the dates of each day, Column B has a
figure next to the date that an amount was paid. Some days have nothing
in column B.
A.........B
1/1/05 10
2/1/05
3/1/05 5
4/1/05 5
5/1/05
I have to produce a statement of payments received. Therefore I want a
listing of the date with the amount received to be generated
automatically.
from above:
1/1/05 10
3/1/05 5
4/1/05 5
Any help would be very much appreciated.
thanks
adrian
--
myty
------------------------------------------------------------------------
myty's Profile:
http://www.excelforum.com/member.php...o&userid=24592
View this thread:
http://www.excelforum.com/showthread...hreadid=381844