Pull a date when it meets criteria and it's text is bold

Hi,

I am trying to come up with a Macro that will pull a date from column B of one sheet into Column B of another sheet when the values in Column A of both sheets match and when the date in Column B is Bolded.

EX:

A B
ACE 1/7/2014
ACE 1/1/2014
HAT 2/4/2014
HAT 4/9/2014

In this case I want the Macro to only pull the bolded dates. On the second sheet ACE and HAT will only appear once. If there is an easier way to do this with a formula that would be helpful too but I don't know of any formulas that will recognize cell formatting. Possibly this can be done with a custom function.

Thanks,
Justin

Got the solution..

Try the following code...

Formula:

Please Login or Register  to view this content.

Check the attached file...


Don't forget to click *

That worked perfectly thank you.