multiple files macros

  1. K

    How to include file names while merging multiple files through VBA

    Hey, there! I am trying to merge about 400 excel files into one master file, which I have been able to successfully do. HOWEVER, I also want the first column to include all the file names corresponding to the data. Can anybody help with that? I am quite new to VBA and trying really hard to...
  2. F

    Trouble with merging Data in one Excell

    Hi, Today I have tried to set up a VBA code in Excel to merge multiple data into one Excel-file. I have a Test folder with multiple Excel files and i want to read multiple cells from each file into one New Excel file. Below an overview of the code. Where I get stuck is reading the multiple...
    • F_Doorn
    • Thread
    • dim multiple files and sheets multiple files macros nrow set
    • Replies: 7
    • Forum: Excel Questions
  3. C

    Multiple files into one BUT different tabs

    I would like to pull multiple one tab reports into a single file BUT I want each of the files on its own tab I have report that I pull from a another system into an excel sheet. Each day I save this file with that days date. The file has the same headers but the data changes. I have several...
  4. M

    How to create multiple files?

    Dear All, I have a following dilemma: I need to create multiple files from a single file while automatically changing one cell. the file is called "Property1 20100931" Sheet1!J3 contains date let's say 9/31/2010 I need to create 30 files with decreasing date i.e. changing DATE in Sheet1!J3...

Watch MrExcel Video

Learn Excel 2010 - "Next Invoice Number": Podcast #1505

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