![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Apr 2002
Location: iceland
Posts: 138
|
Hi guys.
I have a big problem, but Im gonna simplify it, so it is easier to explane. In sheet1 i have a table (A1:K20) which is filled with values(number or text), sometimes the value in column C is emty. I wanna copy the lines in this table(automaticly) to sheet2 (to a new table),BUT I dont wanna copy the lines where cell C is empty. this new table cannot have any empty lines. Have I make this understandable? Is it possible to use IF-function? If you have an Idea please share it with me? BK Stulli |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Apr 2002
Location: Sarasota, FL
Posts: 1,539
|
you could copy the table just like it is to the new sheet, then sort it so the blanks are on the bottom.
corticus |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|