I have excel 2003 workbook (wb_master) with 20 sheets, each of them has a macros (copy filtered data and then paste them to another excel workbook (wb_1...wb_20)). So I have then 20 excel workbooks (wb1....wb20) to which these filtered data from each are pasted. I have made in this wb_master one general macros (mac_general) which runs all macros from all 20 sheets at once. The problem is - I can't run mac_general for updating data without opening all 20 workbooks - wb1.....wb20.
Is it possible to run mac_general without opening all these 20 excel files?
Bookmarks