Might be a hard one (or what?)

stone · May 14th, 2002, 09:41 AM

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

Corticus · May 14th, 2002, 09:47 AM

you could copy the table just like it is to the new sheet, then sort it so the blanks are on the bottom.

corticus

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 09:41 AM	#1
stone 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

May 14th, 2002, 09:47 AM	#2
Corticus 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