View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lversteeg Lversteeg is offline
external usenet poster
 
Posts: 5
Default Eliminating Blank rows

I am hoping someone can help me!!!!

I have on one sheet a product selector for my sales team. I have added a
column where they can put an "x" into if they would like to quote that
product to a client. I have created another sheet called "Quote" where the
prodcut details are automatically updated from the "Product Selector".
However if they choose the products listed in ROW 1 and 3 they are copied
the same way to the quote with blank lines in between. How can I make sure
that they are copied over but without the blank lines


A
1 =IF(ProductSelector!R12="X",(ProductSelector!I12), "")
2 =IF(ProductSelector!R13="X",(ProductSelector!I13), "")
3 =IF(ProductSelector!R14="X",(ProductSelector!I14," ")

And so on, the problem is that if they put and "X" in B1 and B3 the formula that is brought over to the other worksheet is also in A1 and A3 and want to know if there is something that I can add to the formula so that if A2 is blank the result from A3 is moved to there.