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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top