Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split data to different Excel files
Dear group members,
My need is to parse Excel file. I have names of departments in F column: aa ab ac df (et cetera, 30 departments) I have list of departments and other information in my source Excel file. My task is: 1) copy three first lines of sheet "as is" 2) copy all strings with "aa" in F column, 3) paste to other Excel file and to save it as C:\destination\aa.xls Then to do the same for "ab", "ac" and all the rest 30 departments. Tell me please how do I perform this. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split an Excel file into separate files | Excel Programming | |||
Macro to split excel file into seperate files and then email | Excel Discussion (Misc queries) | |||
Macro to split up Excel files that are larger then 65,000 rows Options | Excel Programming | |||
split one excel into two files. | Excel Discussion (Misc queries) | |||
Can I split up an excel spreadsheet into multiple files by rows? | Excel Discussion (Misc queries) |