sheetA
A B C
data1 data 1a
data2 data 2a number
data3 data 3a
data4 data 4a number
data5 data 5a

sheetB
A B C
data2 data 2a number
data4 data 4a number

There are 2 worksheets above. I want data in Sheet A to appear in Sheet B if
any cells in collumn C has a number.
To make things more interesting, I have several "Sheet A" with different
sheet names.
Please help
Thanks.
--
Regards
FangYR
Malaysia