Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically move data from one worksheet to another | Excel Discussion (Misc queries) | |||
How to move data from one sheet to another automatically | Charts and Charting in Excel | |||
move data in cells automatically | Excel Worksheet Functions | |||
how do i automatically move data from rows to columns? | Excel Discussion (Misc queries) | |||
How to enter data then move automatically to new cell? | Excel Discussion (Misc queries) |