multiple workbook

  1. D

    VBA function (i.e., Sum expenditures over multiple worksheets in one workbook into another workbook)

    I need to sum the expenditures of multiple projects defined under several worksheets. Each project is named on the worksheet tab. The first workbook contains the expenditures per month per category. The categories are "Labor" and "Material". The expenditures (i.e., under the first workbook)...
  2. S

    One VBA Userform Feeding a selected Workbook

    Hi all. Our business is moving away from a third party that looks after our sickness. Whilst we await another (possibly), I have been tasked with creating an interim solution. What the powers that be have asked for, is a central user form that can populate a selected Workbook. As we have...
  3. X

    VBA Find Value from one Range in another Range

    I am in need of some help to do this in VBA. I have a range of values in a Workbook1.Sheet1.F2:F1048576. I wish to check if any of these values appears in a second range in Workbook2.Sheet1.A2:A1048576. (The actual length of each of both ranges will vary, hence why I've used the full length...
  4. E

    VBA - Copy from multiple workbooks to single workbook with corresponding sheets

    I have a somewhat specific issue that I haven’t found an answer to on here or anywhere else Every day, I have 89 workbooks of exported info whose data needs to be added to a single daily master workbook. The tricky part is that the master workbook has a separate sheet for each of the 89...
  5. T

    Automatically Add Sheet from Different Workbook from Specified Folder

    I have a master file and a Data Folder that contains workbooks with the same format. I also have a VBA code inside the master file that is able to copy the first sheet of all the selected workbook Sub Merge_Files_First_Sheet_Only() 'Merges all files in a folder to a main file...
  6. D

    Extract differences from different workbooks

    Hi everyone, I hope you are well. I have a spreadsheet that evolves every week. I used Power Query and imported the workbooks produced the past weeks, basically copying the query and simply modifying the source. Is there a way to remove alla common data (what remains unchanged basically) and...
  7. M

    VBA to copy data from multiple work book to one work book

    hello, I want macro for copy data from multiple(nearly 100) workbook placed in one folder to one master workbook with detail bellow. All work books having sheet name "list" from that sheet I want to copy cells C9, H9, H10 and H24:H29 from which H24:H29 contains formulas but in master work book i...
  8. dreen

    Copying data from cells onto multiple workbooks VBA error

    Hello, I can't seem to get my module 8 to paste the values of Sheet1 (workbook where the VBA code is) onto another workbook's cells, I will briefly explain my code: I have three workbooks, one workbook (with Sheet1 being the "Operator" sheet) where the VBA code is written in, and another two...
  9. S

    Copy & Paste all from all workbooks in a folder to new worksheet

    Hi there, I need to specify a date and if it matches a date in column A in a different workbook I need to copy the whole row and paste it in a different workbook, and then loop through and copy/paste. Ideally I need to cycle through all workbooks in the same folder and copy paste from each of...
  10. R

    Multiple workbook into a Masterwork book

    I'm trying to get the information from multiple workbook that follow the same template but with different information on each one into one master workbook but I'm having trouble as the multiple workbook will constantly be changing as more support calls are made, I tried to write the code below...
  11. V

    VBA or Formula on IF function to copy data to another Workbook

    Hi, I am reasonably proficient in excel but VBA is not something I have invested time in and am therefore seeking help for the problem I have. I have 10 workbook trackers hosted on google drive that my team all enter in to for capacity management purposes. I would like to introduce a tick...
  12. R

    Import data from workbooks, convert them and paste it in "main" Workbook

    Hello MrExcel forumers and experts, For sometime now I'm facing this problem I have and I'm hoping that you guys can help me solve it. I've tried using the advanced search but none really solve the exact issue I'm having. Here it goes: I need help extracting and editing data from several...
  13. M

    How to Copy Multiple Worksheets to a New File with Tables

    I have a workbook consisting of two sheets that I want to move into a different workbook. One is the front end worksheet, the other is for data validation, including several tables (which I need as tables to make the front end work). I tried simply selecting both of them and using the Move/Copy...
  14. L

    Multiple Referencing Between Workbooks

    Hi, Recently my boss has requested I take on a job which my predecessor used to do which is meter reading. I'm happy to do this as its a very simple task but it is very time consuming, this is because on the site I work on there are multiple tenants who require a separate workbook for their...
  15. T

    Ignore Remote Requests not sticking when opening a new Workbook.

    Hello, :) I have this nifty macro that I use to launch a userform and hide the workbook. Before I went to Excel 2013, it worked great. Since then, every time I launch Excel (only the program, not individual workbooks), the userform and the Workbook close. Because they were forced closed by...
  16. A

    VBA help required: to create multiple workbooks from one workbook and also paste data in those workbooks.

    This forum is really helpful. I have been learning so much from the forum users. First of all thanks all :) So I have below questions regarding creating multiple workbooks from one sheet. My steps are 1. There will "first.last name" in Column A. Sort column A for A to Z.. 2. For all unique...
  17. S

    Excel IF(ISERROR Formula Error

    I am having issues with a complicated formula that has previously worked. In the past this formula insert text in 70-100 cells. Now I am only yielding text in about 15 cells. The goal of the formula is to copy the text from cell CO3 into cell CP2, if cell E3 = "system" and the text in CO3 is...
  18. S

    Copying a tab from the active workbook and pasting in another workbook as a new tab.

    I am trying to add this template to every excel file in a folder. I have the loop down to run the macro on every excel file in the folder. however, I cant seem to get the macro down to copy the tab and paste the tab. I appreciate all your help, I'm new at this! Sub...
  19. I

    Apply a macro across a hundred workbooks, and then copying the results into a master Excel

    So far the code loops through all of the files, but only copies sheet 1 instead of making the combined sheet. It also creates hundreds of blank sheets in my new workbook that only has 1 combined tab that keeps looping the same information from the first file in my directory. <code...
  20. H

    Summing one cell from multiple workbooks in a folder!

    Hi All, I have about 200 different files -- they all have an identical worksheet (same tab name) with data in the same places - I want to create another worksheet in a different workbook that takes the sum of every cell in every one of those worksheets (basically another identical sheet with...

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