Copy Row
 

Hello,

Id 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,

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,

Hi,

How can I multiply to value in U14 by -1 ?

"Bernie Deitrick" wrote:

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,

Jeff,

If you are using the MAX formula in U14, simply use a minus sign after the
Equal Sign.

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

or if you need it in another cell,

=-U14

HTH,
Bernie
MS Excel MVP

"Jeff" wrote in message
...
Hi,

How can I multiply to value in U14 by -1 ?

"Bernie Deitrick" wrote:

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,