| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 110859 | 2010-07-04 13:18:00 | excel, macros involving filters. | ravana (15869) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1115803 | 2010-07-04 13:18:00 | hi, I just want a macro to help me out a job. I have a set of names about 50 in file(say worksheet "list") and each name has a separate excel file in a single folder. i need to open each excel file corresponding to their names and filter non blanks from a column in that and put it against each name in worksheet: "list " |
ravana (15869) | ||
| 1115804 | 2010-07-05 05:59:00 | Microsoft help should have some tutorials like Macro to open multiple files (support.microsoft.com), or this excel forum for macro for multiple files (www.eggheadcafe.com). Or maybe Excel pro John Walkenbach's site (spreadsheetpage.com/) who might have resources and tips. But back up your files first. | kahawai chaser (3545) | ||
| 1 | |||||