multiple files

  1. T

    General Precautions we can take while operating 2 excel sheets

    Hello Gurus, I am working on an item, where I need to compare 2 excel sheet ranges, Say File1 Sheet1& File2 Sheet1 I am invoking File2 Sheet1 by File.Open Copying the respective range from file 1 & file 2 into Rng1 & Rng2 I am concatenating column values for each row in Rng1 & Rng2 & putting...
  2. E

    Comparing data from worksheets in a folder

    So I am trying to compare and match data from 2 workbooks in a folder at once. There is about 700 workbook files in the folder. For example: compare the cells in workbook 2 to workbook 1 and the cells in workbook 2 that are not in workbook 1, paste the cells and show the number of cells. The...
  3. 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...
  4. U

    VBA Remove Password on Word Documents

    Hi Guys, I'm using below codes to remove password and save excel files without password. Can you help me modify the codes so I can use this for word files? =================== Sub RemovePassword() Dim xlBook As Workbook Dim strFilename As String Const fPath As String = "C:\My Folder"...
  5. D

    Transfer of data divided into chunks from one file to multiple files.

    Hello everyone, I have multiple destination workbooks each one with a list of 100 symbols (one symbol per cell) in column A starting from cell A25. I have also file "Source.csv" with a list of 2000+ symbols in column B starting from B2. To copy and paste all 2000+ symbols in the column of a...
  6. K

    Errors with sending different pdf attachments to different recipients - VBA

    Hello all, I'm attempting to help a coworker automate part of her daily tasks. A PDF named in the same format is sent to different people about once per day. IE Person A gets his company's invoice, Person B gets his company's invoice...etc, etc. Invoices are all named in the same fashion -...
  7. S

    Code to remove specific lines from a large number of .csv files

    Hello all, I have no prior knowledge of VBA code, so please bear withme if this question has been answered before in some way or another. The context of the problem is that I have a relativelylarge (>100) number of .csv files which all follow the same format and the samethree rows need to...
  8. D

    Conditional formatting; Format Fields based on values in another file

    Is it possible to setup conditional formatting on a field in one spreadsheet based on the value in a cell in a completely different workbook? here's my situation... I have one file (File1.xlsx) with a dashboard of red, yellow green formats via a dropdown list of R, Y and G I have a second file...
  9. D

    Macro to print specific sheets from multiple spreadsheets

    Hi everyone, I have folders for each of my students containing a spreadsheet with their performance. every week i have to open up each individual file and print out 2 specific sheets from each file, week x and week x progress report. it usually takes me all morning, but I was wondering if there...
  10. T

    Calculate and Report Median on Multiple Files

    I have over 200 excel files that have the same headers but different number of records for each. I need to calculate the median for column F for each file and then report that median (on one file if possible) for each file using the filename of said file. Is this something someone can help with...
  11. L

    Combining data from multiple workbooks in a folder into one file

    Hello everyone, I'm in desperate need some some VBA help! I have a number of identical files saved in a folder which I basically need to combine into one report. The format of each file is as follows - <tbody> A B C D E F G H 1 Employee Name 2 Employee Grade...
  12. M

    Macro to Import Multiple CSV files into specific Excel tabs

    Hello, I have a project that I'm hoping to get help with. I need to import multiple CSV files into specific Macro Enabled Workbook that already has uniquely named Worksheet tabs. I have code to do this for 1 CSV file into 1 worksheet tab. However I have 7 CSV files (always the same CSV file...
  13. C

    Retrieving Data from old files to paste in new files via Macro/VBA

    Any help is greatly appreciated. To simplify: -I have multiple files for 2016 say files A, B, C, D, E, F (each file is labeled with the year at the end ex. A 2016.xls) -I need to copy certain data (all on one worksheet) for the same files from 2015 (A 2015.xls, B 2015.xls, etc.) into the 2016...
  14. A

    Multiple files within a single tabbed window

    How I can view and edit multiple files within a single tabbed window. I wants a tabbed user interface - as seen in web browsers such as Internet Explorer® 8, Firefox and Google Chrome. Note: I am using office 2013
  15. S

    2 excel files opened on different screens

    I use to be able to have multiple excel workbooks, in the same session, open and could move them from one screen to another. Under this functionality i could move or copy sheets between workbooks. IT did something to my computer and now they tell me that this functionality is not possible...
  16. Scotwho

    Assigning passwords from a list to multiple files.

    I have a workbook that through VBA parses a worksheet into separate workbooks based upon the criteria in a specified column and then names and saves the different workbooks. No problem, this macro works great. I then have another macro that sets each workbook a password from an assigned list...
  17. O

    split excel file into multiple files based on column

    Hi guys, I am trying to split an excel file with over 100 000 rows into different files based on the values in column A. In this case cases A2-A62 have value "1", cases A63-A89 "2", .., cases A120 569-A120601 "120". Row "1" includes headers for the columns. I am not very experienced with...
  18. K

    Colsoldation of multiple files to one master

    Dear all, I am trying to consolidate multiple excel files with different sheets to one file that was initial file that was split into several files. So I have multiple files that contains part of the file and I would like to collect the feedback from that in the Initial master file. My logic...
  19. D

    Multiple text file importing

    Hi guys, I want to store data in 1 worksheet from multiple .txt files. Also, I want the first cell to contain the file name not the file path (if possible) so I can link it to the graphs later on. There is also AT MOST 7 columns in the data while the number of rows is variable and the first...
  20. J

    Run Access Query Using Pulled In excel files without duplicating data

    Hello, I have been running a report weekly using the below code in a module to pull all of the excel invoices I need into a query. My issue is that every week I have to rerun the report from scratch because if I just click run it will re-pull the same files I already have in it again. Is there...

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
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 "".
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