multiple workbooks

Hi need help completing a SUMIFS(INDIRECT function that will gather data from another workbook. I am trying the below formula but it I get a message saying theres an error, but I'm not that great at this sort of stuff. =SUMIFS('[WEEKLY SALES PERFORMANCE.xlsx]'INDIRECT("'"!$H:$H),'[WEEKLY SALES...

So I want to apply a simple formula to calculate closing Balance i.e. 'Closing Balance= Opening balance + purchase - sale' But there are many complexities. the main issue is. I have 3 workbooks, Workbook 'O' and Workbook 'T' and Workbook 'CT' Workbook 'O'- containing Opening balance as on...

I have VBA code which retrieves historical stock prices data for the last number of periods (days, weeks or months) up to the endDate specified by the user in the workbook. If I try to download data for more than 100 shares at a time, the speed of download progressively decreases. The only...

Need help to solve a tricky situation: I have an workbook with two sheets: "sheet1" containing on column A the working days of a year and on column B the months of a year and sheet "Template", which contains a template (with formulas in it). (1)By clicking a button I want to (2) create 12...

The goal is to: write a VBA Code to copy data from (specific sheet) in multiple workbooks and paste rows with content to Master Workbook. I have spent the last few days working on this, but I was really excited to come across this site. Current, when the information desired is copied, I noticed...

Hi Hoping someone can help, I need to gather data from multiple worksheets on multiple workbooks The below gives me #REF error =SUMPRODUCT(INDIRECT("'"&$C$5&"'[JAMIE SHEET METRO.xlsx]!'""'c$12:c$25"),$C$9:$C$22,INDIRECT("'"&$C$5&"'[JAMIE SHEET METRO.xlsx]!J$12:J$25")) Cell C5 refers to tab...

Hi, I have 30 files in the same folder (P3/2014/PPD Data) one for each month (last 30 months). Each file has approx 6000 rows of data with prices for the drugs for that month. I need to extract the data relating to only 5 of these drugs over the 30 months (call them drug 1, drug 2, etc). The...

Hi all, I am looking for a macro that will open multiple excel files in one folder location (to be input by the user) and extract only the tab named "Output" into a master file (which will be the workbook with the macro). Ideally, the "output" tabs would be renamed to the source file name and...

Hello all! I'm struggling with a macro that I'm trying to create that will pull data into a Master workbook from a different workbook that is updated weekly. The problem I'm having is that the file I receive weekly is always named differently (updated for the week ending) and 7 of the 8 tabs...

I have two workbooks, each with a Keyboard shortcut assigned to the same key stroke combination. Both of the shortcuts do similar things, e.g. delete or add rows, but because the workbooks are different in terms of number of columns and content, the Macro can't work exactly the same in either...

Hi, I am trying to merge data from a number of excel files (60+) into one spreadsheet. The header rows are the same, however, the number of records in each file is different. Can someone please help with a VBA code that can copy data from each file and add them all to a single worksheet in a...

I have a main workbook that I open that has code in it. when I run the code on that workbook it copies some data, opens a template workbook, pastes the data into the template workbook, runs a macro that is in the template workbook, and saves the template workbook with a new name and closes it...

I'm trying to create a formula that will look up the same cell only across multiple workbooks. Someone has created a new workbook each week and entered one point of data I want to collect over time in the same cell of each workbook. Each work book has the same name but ends with a different...

In workbook 1, columns A-D have employee info (first name, last name, division, and supervisor) and columns E-H have dates trainings were completed In workbook 2, columns A-D have the same employee info but columns E-K are tracking employee schedules and attendance In workbook 3, columns A-D...

I'll try to explain this as concisely as possible. I have been given the task of cross-referencing several workbooks and creating a new, more easily-understandable excel document to be distributed internally within the company. It occurred to me that it would go much faster if I could apply a...

I have a project that has a dropdown list for user selection based on the item selected, I want to be able to write user data to a different tab of the destination workbook. For example if user selects "Banana" from the list I want the submit button to go to "Workbook2" then set Worksheet to...

Does anyone know if it is possible to link pages in multiple workbooks. I want to be able to click on a upc code in a cell and have it take me to the same upc code in a separate workbook. Does anyone know how to do this? Basically you would have to search by the upc code. I have done this in...

Hi, I want to create a spreadsheet that will pull data from a form that my clients use. There will be many of these forms and each one will have a slightly different file name but be stored in the same folder (C:\Users\MWa\Desktop\VBA Test\filename) I want to copy the exact same cells from...

Hello everyone, I was searching through the forum for a solution on using Index/Match but I didn't manage to find one solving my problem. I have two excel documents. The one of them contains information about participants of a quiz. Each week I have to retrieve the participants of the quiz and...

Greetings all, I have an analytical piece of equipment that exports data for each sample analyzed into a separate .txt file. I would like to compile all of the data from analyses performed on one day into one summary workbook. All of the exports are in the same format but the location of the...