closed workbook

  1. D

    SUMIF for closed workbook

    Hi, We have several target sheets that run using the formula below. I have been told that they always used to work without having the source book open but from researching online i dont see how it was possible as they have always been using sumif. could you have a look at the formula below and...
  2. H

    References to external workbooks not working unless they are open

    Quick question regarding some references I have to external workbooks. The formula in question is: =VLOOKUP("*"&B5,INDIRECT('Links to Workbooks'!$I$3),'Links to Workbooks'!$C$4,FALSE) Where the lookup value B5 contains "Total Revenue" and is what I am hoping to match using VLOOKUP in other...
  3. N

    Counting data from an external workbook

    I have been trying to count a column of data based on specific criteria. Here is an image of my data: The data in column A is actually in an external workbook (for simplicity I am showing it all in one image here) and I am using the SUMPRODUCT function to try to count how many times any time...
  4. T

    SUMPRODUCT returning 0

    Hello all! Just started learning more formulas and VBA scripting for my job, but I'm running into an issue with the SUMPRODUCT formula returning 0 instead of the actual number. My intent was to have this run through the specified closed workbook and range and then return the number of cells...
  5. S

    Retreive info in closed workbook on Sharepoint

    Hi teamies. I have an interesting problem that I cant seem to find a solution to. I have two workbooks, lets call them BookA and BookB. BookA is left closed most of the time and is accessed through Sharepoint. BookB is updated several times a day (also accessed through sharepoint). BookB has...
  6. C

    Auto combination/update of data from multiple closed workbooks into a single summary workbook

    Hi there, This is my first post here, although I have utilised this forum many times by reading other threads to help me solve my excel problems. Unfortunately this time I have been unable to reach a solution myself, so I'm hopeful that someone may help educate me. I am relatively novice at...
  7. F

    Vlookup using a cell containing a reference to closed workbook array

    Hi all, I am trying to do the below VLOOKUP, however I am getting an error. The Source Workbook is closed and I would like array to be a cell in my workbook (G1 in this example). Anyone have any idea if this is possible in Excel? Any help would be greatly appreciated! <tbody> A B C D E...
  8. S

    Copy Pasting with VB from a Closed workbook to a open one

    Hello, I have a solution to a problem which I do not have the knowledge about VB to get there. My issue is I have a inventory count with a Button that I'd like to allow the user to click and be able to upgrade copy and paste by accessing a closed Inventory log workbook looking at a column...
  9. J

    #Value with SUMIFS referencing a closed workbook

    Hi all, I am attempting to clean-up one of my dashboards by linking it directly to the source data rather than via an Access database. I have hit a problem with #Value errors from a SUMIFS formula. I have found from reading many threads that this function is not compatible with closed...
  10. S

    Changing date while referencing closed workbook

    Hi Everyone, I am trying to reference a closed workbook that is updated daily. Below is my formula `=SUMIF('L:Path\[filename - "&TEXT(WORKDAY(TODAY(),-1)),"yyyymmdd")&".xlsx]Sheet'!$DX:$DX, filename - "&TEXT(WORKDAY(TODAY()-1)),"yyyymmdd")&".xlsx]Sheet'!$BF:$BF,"criteria")` Will the TEXT...
  11. S

    Is it possible to do a countif in VBA using a closed workbook?

    Hi all. My current dilemma is this: I am writing a macro that will do a few things but I am stuck at having to do a countif using a range from a different workbook. Now this workbook is a binary one (xlsb not xlsx) and is password protected. It has multiple sheets as well. What I want to do is...
  12. R

    Advanced filter from closed workbook

    Hi, I am trying to pull data from a closed workbook using advanced filter. here is what my code looks like right now. It works fine if I have both the workbook with the criteria as well as the workbook "ORDERS CHART" open Sub Macro1() Range("Sheet2!A1:AU999").Clear...
  13. C

    Need Help with External Links to Closed Workbooks that Change Folders

    Hi all, first time posting. I have a master tracking document (WB1) that needs to return values from an external workbook (WB2) even when WB2 is closed. I have done this successfully using workbook cell formulas. However, WB2 has to be moved around within a shared folder structure. I'm trying...
  14. A

    recordset.find unable to find value from closed workbook: Item cannot be found in the collection corresponding to the requested name or ordinal.

    Hey everyone and thanks for all your help in the past! I'm trying to search for a value in a closed workbook and if that value is found, I would know that that unique ID has already been used and move onto the next number. I'm choosing to use the ADODB method instead of having it open in the...
  15. S

    Getting value from closed workbook

    Hi there, I have this code which extracts the values I want from the spreadsheet I want, however there is only one problem - hopefully an easy fix. This extracts the data from rows 5 to 28 and columns 26 to 36, but inputs these values into my sheet in the same place. I would like the macro to...
  16. J

    COUNTIFS closed workbook

    I'm trying to rewrite a COUNTIFS function so i can use it with an closed workbook, by using COUNT(IF(AND... I want to count the number of data that has B3 in column AW, E2 in column AN and D3 in column AU. The following function works for that...
  17. P

    Macro for pulling data from a closed workbook

    Hi all, I'm new to the forum and new to VB, and was wondering if there was anyone out there who could lend a hand with a problem I'm having concerning pulling data from a closed workbook by using a macro. I have tried Google to resolve the issue, but am only getting very basic results which do...
  18. L

    Counting cells based on multiple criteria "between two dates and one other criteria" in closed workbook.

    Hello, First time posting on MrExcel. You guys have been great by helping me just by Google searching but I am hoping that you can help me with a formula. I am trying to count the criteria "Any cell that equals 10 in column K" between two dates in column A in a closed workbook. In the sheet...
  19. B

    #REF! when closing External Link

    Hello All, I have an array formula that is only working when the linked spreadsheet is open. I am referencing a table, is that the problem? The formula when both sheets are open: {=IF(ROWS(B$6:B6)>$G$2,"",INDEX('[Serial Number Tracking.xlsm]Serial Credit Sheet'!A$2:A$76049,SMALL(IF('Serial...
  20. J

    VBA to list path and file name

    Hello, I have a VBA script to list worksheets from a closed workbook. The script works great, but I can't seem to get it to list the file location and name. Does anyone have an idea about how I could get the file path and name to show up? Thanks! Option Explicit Public Sub...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    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
    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
    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
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    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