Macro To Match Column Against Row Criteria

Trying to write a macro that will display either an 'X' or a date under a specific header if several conditions are met across a row in another tab.

I have two tabs, one is the report, the other raw data. On the raw data tab, if the macro finds a row where the title, territory, Rowdesc, start and end dates all match criteria, then display an 'X' next to that title in the report tab. The criteria would be:

Title Match - between Raw Data tab and Report tab
Terr_Nm column matches report header in Report Tab
Rowdesc = 'No Rights'
Start Date = the date 1-Jan-1900 or 1
End Date = * - an asterick

However, if the macro finds a start date that is greater than today, display this start date on the report where the 'X' would normally go. If the macro finds a start date that is less than today and an end date that is greater than today, then display the end date where the 'X' would normally go.

If the macro does not find anything, then do nothing and go on to the next row. In my example, 'Title 4' isn't on the raw data, so the macro would do nothing with this title.

Raw Data:
Title
Terr_NM
Rowdesc
Start
End

TITLE1
Terr X
No Rights
1/1/1900
*

[Code] ....

Report Tab, before running macro:

TITLE
Terr X
Terr Y
Terr A
Terr B

TITLE1

TITLE2

TITLE3

TITLE4

Report Tab, after running macro:

TITLE
Terr X
Terr Y
Terr A
Terr B

TITLE1
X
1/1/2015
X

[Code] ......

I've tried doing this with formulas (dcount, countif, etc.) and the problem is displaying the specific date. So, I'd like to use VBA to automate.