hi to ALL,
id like to know how to generate worksheet based from another worksheet without blank rows. shall we say in worksheet A,contains data
no. name data1 data2 data3
1 aaa 095 0 099
2. (blank) ---- --- ----
3. fff 0 345 234


how do these data be transferred automatically to another sheet without blank rows. what will appear in the next sheet then would be
no. name data1 data2 data3
1 aaa 095 0 099
2. fff 0 345 234

thanks.
monodon