Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminating blank cells | Excel Worksheet Functions | |||
Eliminating Blank Values | Excel Discussion (Misc queries) | |||
Excel 2003-eliminating blank rows in target worksheet | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Eliminating Blank Rows | Excel Discussion (Misc queries) |