automatically move data to another file

[reza]

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

 

[Dave Peterson]

You could copy the data to another worksheet.
Then sort that data. The blank rows will either move to the top (and can easily
be deleted) or move to the bottom (and can be ignored).

But your sort won't be in the order you showed. It'll be in alphabetical order
(or reverse alphabetical order)--depending on what you choose.