Hi All,

Need your help guys...MS Excel 2007
i have data from one file and want to move it to another file.
with data like:
A1 Refill, 100 respondent, 100 validasi
A2 verification, 80 respondent, 20 validasi
A3 education, 60 respondent, 20 validasi
A4 Refill, 70 respondent, 60 validasi
A5
A6 education, 60 respondent, 20 validasi
A7
A8 verification, 80 respondent, 20 validasi
A9 education, 50 respondent, 20 validasi
etc

every Task always have 3 sub task (refill, verification, education).
from above, i want to move data to another file/worksheet...
1. i want to move that data automatically to another sheet/file but not
include with empty cell...(like A5 and A7)...
2. can that data move but sort by alphabet....
Refill, 100 respondent, 100 validasi
Refill, 70 respondent, 60 validasi
verification, 80 respondent, 20 validasi
verification, 80 respondent, 20 validasi
education, 60 respondent, 20 validasi
education, 50 respondent, 20 validasi

many thanks in advance

reza