LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Eliminating blank cells PointerMan Excel Worksheet Functions 10 December 30th 08 11:41 PM
Eliminating Blank Values Ken Excel Discussion (Misc queries) 2 November 9th 08 05:18 PM
Excel 2003-eliminating blank rows in target worksheet Rich D Excel Discussion (Misc queries) 0 January 3rd 08 06:33 PM
Copy rows of data (eliminating blank rows) from fixed layout Sweepea Excel Discussion (Misc queries) 1 March 13th 07 11:05 PM
Eliminating Blank Rows Tatebana Excel Discussion (Misc queries) 4 February 19th 07 05:24 PM


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"