Copy Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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

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

Bernie Deitrick said:
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 said:
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,
Click to expand...
Click to expand...
 
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 said:
Hi,

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

Bernie Deitrick said:
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 said:
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
Click to expand...
Template,xls"
in
order to copy the row with the greatest value. Is that possible?
Thanks in advance for any help,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top