consolidate files

  1. P

    Querying a single cell from multiple workbooks

    I have a large number of workbooks all created from the same template file. They are all formatted in an identical manner, and each worksheet has a timestamp in cell A4 that I'm interested in extracting. I'm trying to consolidate the filename and timestamp (cell ref A4) from each worksheet...
  2. A

    Consolidate multiple file in designated folder (Invalid code for long figues)

    I used the following code to consolidate the data in multiple files in a designated folder. The codes work perfect when the source files are excel but there is issue with csv/txt file. When it is csv/txt file, if value of the cell is some figures with many digits, the copied value changes in...
  3. A

    Consolidating 2 Excel Workbooks into one workbook

    I am trying to consolidate 2 Excel workbooks that have multiple tabs. There are 2 people working out of the same workbooks each saved to their own computer but not necessarily working on the same tab. Anyways, once each person has worked their sections then it is time to combine the tabs in...
  4. B

    Consolidate worksheets & copy the name of the tab in a column

    Hello, I am trying to consolidate a spreadsheet with 45 worksheets. I want to copy all the data into one worksheet and call it master. I also need to copy the name of the worksheet next to the data in a separate column. I have three columns: 1) Recipient 2) Email Address 3) Comments the...
  5. T

    Macro

    I get sent 5 seperate excel sheets from different teams on a monthly basis. I then normally copy and past them into one overall monthly sheet. Is there a Macro that can automatically do that, any help appreciated

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top