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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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