-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
multiple files macros
-
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...- kaywantstobeexcelmaster
- Thread
- Replies: 6
- Forum: Excel Questions
-
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
- Replies: 7
- Forum: Excel Questions
-
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...- ChicagoGuy
- Thread
- Replies: 1
- Forum: Excel Questions
-
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...- manbearpig
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...