Dates are arranged in ascending order in Row 1. The data contained in the
cells is the $ value of the receivable as of that date. It is column H I am
trying to populate.
A B C D E
F G H
Acct # Name 11/30/2008 12/31/2008 1/31/2009 2/28/2009
3/31/2009 1stDate
1234567 ABC Co $10,001.
27 $10,001.27 2/28/2009
2345678 BCD Co $47,
161.57 $47,161.57 2/28/2009
3456789 CDE Co $10,000.00
12/31/2008
4567890 DEF Co $5,500.00
???

Thanks.


The Code Cage Team wrote:
How is the data laid out in your workbook?, are dates in their seperate
cells?

Pleasehelp via OfficeKB.com;324122 Wrote:
I have a spreadsheet with 24 months across the columns. The rows
contain
[quoted text clipped - 11 lines]
Outlook, PowerPoint, Publisher, InfoPath discussions.'
(http://www.officekb.com)


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1