accumulating notes

S

sunroyal

Hello,

I am working on a productivity sheet that concatonates (vertically), 4
lines of notes at the top of a single page, from the horizontal notes
below. I want the notes at the top only to show the last row of notes,
each time a new set of notes is entered.

Ex. (notes at top) Jim Miller 555-4897
30 day lock - exp date 11/22/03
250 hit for cash out refi
sent confirm to 555-4855


Ex. (cumulative notes) Jan Smithe 548-7878 548 2256 30 day...
Mark Rich 145-4565 fax 859-8686
60 d...
Jim Miller 555-4897 f 555-4855
30 day lo.....(etc.)

Anyone know how this is done...I'm stumped and on a deadline!!!
 
Top