Taking the last value of everymonth for each project

[B2009]

Hi Guys,

I have a little issue with my spreadsheet - basically I want the macro to do the following:

1.Match project in 'Financial ScoreCard'(ws) to 'Project Financial Tracker'(ws)
2. If found, match date(mmm) in Financial ScoreCard to date(mmm) in Project Financial Tracker
3. If found take the last value of the month for each project from the Project 4. Financial Tracker and place in Financial Scorecard under the heading 'Forecast'.

The macro should always check/design the values in the Financial Scorecard from scratch just in case historical numbers have been amended.

I have made a start with the macro so it just needs a little tweak here and there - any help would be much apprecaited as ive been wrecking my brain for some time now - don't think my health insurance covers this sort of trauma.

Thanks in advance