multiple files and sheets

  1. 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
  2. S

    Sorting Data Across Multiple Worksheets

    I have several hundred files, each representing a different date and each containing roughly 500 rows and the same columns. I would like to sort each of these files in the same manner (while adding a few extra columns with calculations) with the ability to then compare and analyze the sorted and...
    • skafin
    • Thread
    • multiple files and sheets multiple worksheet sorting data
    • Replies: 2
    • Forum: Excel Questions
  3. E

    VBA Gather data from multiple files and sheets

    Hello, Every month I get an update of data which is given in different files and sheets (see files "DataFile01 & DataFile02"). What I always do, is that I gather them in 1 table (see file "DataTableResults"). See files: https://drive.google.com/open?id=0B00gFmdiXOT4NnlHcGVlOG5PTUE I have...
  4. R

    Check multiple values between multiple excel Files

    Hi, I have somes files such as bank.xls, office1.xls,office2.xls each having a particular sheet with the following columns Date Payment mode Payee Amount I need to check if the data from the sheet1of bank.xls has been correctly entered into sheet2 of office1.xls / sheet2 of office2.xls eg...
  5. R

    Going from the Excel INDEX command to proper VBA code.

    I need help going from the Excel INDEX command to proper VBA code. I have up to 90 Excel files used for surveying clinic participants. Since each survey will have the questions in a different order, the VBA code needs vertically index to the proper question in the respondents’ files. The...
  6. N

    How do I get Excel to match content of cell and perform an action?

    I will have multiple Excel files that have very similar data in the first column (Company Names), how do I get Excel to find out what the information is in the first column and then post it's website in the 2nd column from a pre-populated list? I have hundreds of Company Names per Excel sheet...
    • nyancat
    • Thread
    • challenging macro multiple files and sheets visual basic vlookup
    • Replies: 2
    • Forum: Excel Questions
  7. N

    merge multiple files and all sheets

    Need your help! Do you know what the macro would be if I want to merge different sheets (having the same amount of rows but columns may be different) for all open files? With other words, I will have 5 files open, some with 5 sheets and some with one sheet and would like to have all columns...

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
Back
Top