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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Condition IF 3
Kinda like a database - I can’t believe others don’t need to do th 3
Button macro to move/delete active row 4
Macro to create a list 5
Excel Help to copy information from one row at a time to another sheet 1
Macro to copy & paste-special-values data to selected worksheets 1
Shading row based on value in one of its columns 1
Help Modifying Macro from Dave Peterson 6

Back
Top