Moving formula results to blank line
 

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

Moving formula results to blank line
 

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" wrote in message
...
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

Moving formula results to blank line
 

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" wrote:

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

Moving formula results to blank line
 

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

A
B
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.




"Lversteeg" wrote:

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" wrote:

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