Moving formula results to blank line

[Lversteeg]

I was wondering if anyone could 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, 5 and 7 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?

I hope this makes sense.
Thanks

 

[Ashish Mathur]

Hi,

Please be more specific with your question. Post an example and tell us
exactly what you want as the result

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Lversteeg]

This is how I have done the formula in the Quote sheet:
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 R12 and R13 then cell
A2 remains blank. I was wondering if I can add something to the formular so
that A3 moves to A2 if it is blank.

I hope this explians it better. It is not as easy to explain as what I
thought.

Lversteeg

 

[Lversteeg]

I think that my last explaination was not clear. Can anyone help me I need to
get this finished!!!!! thanks

A
B