Pulling notes by date from another worksheet according to client code...

[panamakevin]

I have racked my brain with this one all weekend and have so far come up with some pretty messy 1/2 solutions... I thought I'd see if anyone here could lead me in a cleaner direction... Here is what I am trying to do:

I am basically using Excel and Macros to format two different reports into one neat report. I put the two sheets in the workbook (Delinquency & Yardi Notes)

I need the Delinquency sheet to use tenant code (ie C8, C18) and the amount of time the charge is overdue (either 30 days, 30-60 days, 60-90, and over 90, (COLUMNS J:M)) to pull notes from the Yardi Notes sheet and put them in the Notes column(O) starting with the first line of that tenant (newest note to oldest note) How far back the charges go determines how far back to pull notes (90 days old being the max) The notes also need to be word wrapped so they all show up in the notes section. If only 150 characters of each note were transferred that would be primo.

I am having a real hard time getting them to match up with the tenant code and its charges.

I have attached the sheet and anyhelp would be friggin amazing, this project has been a thorn for a while...