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

[jclegg42002]

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 Unit	Short Description	Unit	Qty	Unit Rate (1)	Total	Long Description	Supplier Response Notes/Comments
WNI-100	Install / Mount Antenna or Integrated Antenna	Per Node		$304.62​
WNI-105	Install / Mount Additional Antenna or Integrated Antenna	Per Antenna		$257.75​
WNI-110	Install / Mount Radio	Per 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!!!!

 

[Fluff]

The formula will only return the actual value of a cell, so you will need to reformat the cells, after adding the formula.