Using IF statement > 0 to copy data from separate worksheet - Need help - Brain Fried

jclegg42002

New Member
Joined
Sep 6, 2014
Messages
12
Office Version
  1. 365
Platform
  1. Windows
So I am stuck and I know this has to be an easy fix... I have always used this forum (for years) because it actually has smart people running it! Could anyone help?

Sheet1 contains the following data starting at row 9 (to row 80):

Bid UnitShort DescriptionUnitQtyUnit Rate (1)TotalLong DescriptionSupplier Response Notes/Comments
WNI-100Install / Mount Antenna or Integrated AntennaPer Node
$304.62​
WNI-105Install / Mount Additional Antenna or Integrated AntennaPer Antenna
$257.75​
WNI-110Install / Mount RadioPer Node
$275.33​

if QTY is > 0 (aka 1 or whatever numeric character)

I want to copy that whole row to Sheet2 - I am trying to capture the Bid Unit / Short Description / Unit / Qty / Total / Supplier Comments (this is for change order requests, and I figure copying the whole row would just be easiest)

Can someone make me feel stupid real fast on how I would reach this goal?
Thanks ahead of time!!!!
 
The formula will only return the actual value of a cell, so you will need to reformat the cells, after adding the formula.
 
Upvote 0

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,226,693
Messages
6,192,465
Members
453,725
Latest member
cvsdatreas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top