When sheet2 is in need of update,
Copy the entire Sheet1 to Sheet2
then (with sheet2 as active sheet, Highlight/Select B1:B100 (from 1st to
last)
and run:

Sub Macro1()
'
Selection.SpecialCells(xlCellTypeBlanks).EntireRow .Delete
Range("A1").Select
End Sub

HTH



"tmented" wrote in
message ...

Hi I was wondering how I would go about performing this operation.
I have a list of Items set up in sheet 1, column A, all of them are
text.
in column b I would enter a quantity.
in sheet 2 I want collumn A to reflect the list from sheet 1 but only
if there is a value in collumn B.
this is easy enough to do using an if statement but I would like to fix
it so that if
row 1 doesn't have a value it looks at row 2 and so on The purpose is
to eliminate empty rows in sheet 2.
Can anyone help with this
Thanks
Lisa


--
tmented
------------------------------------------------------------------------
tmented's Profile:
http://www.excelforum.com/member.php...o&userid=26002
View this thread: http://www.excelforum.com/showthread...hreadid=393645