|
automatically move data to another file
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 |
automatically move data to another file
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. reza wrote: 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 |
| All times are GMT +1. The time now is 11:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com