| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to autofilter other file and copy in opened file
Yo,
say i'm in a certain workbook: book1. from there I want a macro to autofilter another file (that is not yet opened) (e.g. c:\other file) based on the value a1 of sheet1 of book1. once the other file is filtered, the filtered range has to be copied to sheet2 of book1. is this possible? thankx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to run a macro automatically when the file is opened? | Excel Discussion (Misc queries) | |||
| How to auto activate macro when file opened | Excel Worksheet Functions | |||
| Close file and run macro from newly opened file | Excel Programming | |||
| How to make macro start when file is opened | Excel Programming | |||
| Copy cells from xls file opened in browser | Excel Programming | |||
Threaded Mode
