multiple file macros

  1. xd9813

    Open, SUMIFS, Close, Rename >5k workbooks (~3GB of data)

    Objective: Provide aggregate sales totals based on multiple criteria in Product Description column from >5K workbooks located within different folders & with different layouts, sheet names, and workbook names. However, all column names are similar (not 100% but close). The names of the...
  2. M

    Macro for copying cells from multiple workbooks

    I am new to this forum and I would be very thankful if anyone can help me out. I need a code that will copy certain cells from all sheets of all files in a folder and then list/paste them down in another master/summary sheet. All workbooks in the folder have multiple sheets and in each sheet the...
  3. ThunderGod

    Saving 2 resulting files from 2 Template files at once with Macros and Buttons removed

    I have created 2 Template files (xltm). For my purposes here one is named Master.xltm the other is named EmailFile.xltm. EmailFile.xltm is referencing Master.xltm ie: =[Master.xltm]sheet1!C$6$ . Both of these files are opened at once via Auto_Open Macro in Master.xltm. Once the data is entered...
  4. B

    Macros for Extracting Data from Multiple Worksheets for a Mastersheet

    Hi there, I'm trying to synthesize a fair amount of averages response time data from about 300 separate worksheets into one master sheet and I'm wondering what the best way is to do it using Excel's macros. In each subject condition-worksheet there are 24 cell items that need to be pulled and...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top