Jeff,

In cell U14, use the formula

=MAX('[Forecast Template.xls]Sheet1'!B5:C5)

Change the Sheet1 to the actual sheet name.

HTH,
Bernie
MS Excel MVP

"Jeff" wrote in message
...
Hello,

I'd to create a VBA Macro with an " IF" condition, in my Workbook B in row
U14, that would evaluate rows B5 or C5 in workbook "Forecast Template,xls"
in
order to copy the row with the greatest value. Is that possible?
Thanks in advance for any help,