hello
i have another question to ask to this great forum!!
this place is great!!

here is my question.

i got a worksheet called "ABC", "DEF" and "LIST"
i have datas stored in ABC and DEF, want them transfered to LIST
i can just simply do "='ABC'!A1" on "LIST" page then just drag all, same
thing for worksheet "DEF"
but i'm too lazy to do that.. or least my boss is... with certain conditions.

here's the condition;

1. ABC and DEF contains datas from formula. some cells are just marked with
"0" due to the formula result
i want it to copy all cells (cell values only) from certain columns from
"ABC", sort itself OR leave out cells that has "0" value,

2. then, same thing for "DEF", add "DEF" data on "LIST" where "ABC" data had
left off.

is this possible for excel?

here's the sample that i would want it to look like;

WORKSHEET"ABC" WORKSHEET "DEF"
A B A B
abcd 1234 ZYX 1098
efgh 5678 0 0
0 0 WVU 7654
ijkl 9101 TSR 3210


WORKSHEET "LIST"

abcd 1234 (start data from worksheet "ABC")
efgh 5678
ijkl 9101
ZYX 1098 (start data from worksheet "DEF" where "ABC" had left off")
WVU 7654
TSR 3210

i hope excel can do this, if not.. oh well..
please help me!!! thanks!!!