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