external workbook

  1. K

    VBA VLookUp Help (Thanks ahead of time!)

    Hi! I am very new to VBA and am trying to write a procedure where I use a vlookup to populate information in my active sheet from an external and closed excel document. I would like to use VBA and not a formula. I need to lookup cell A2 on my ActiveSheet and return the corresponding job name...
  2. 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...
  3. D

    Unable to create relative reference to another workbook

    I am trying to create a simple relative cell reference to a cell in another workbook which copies the content from that cell to my current worksheet. When I do, it creates an absolute cell reference, which works for that particular cell. But if I copy the formula down to the next cell, it is...
  4. L

    Create Arrays from external workbook and add worksheet table data to the arrays

    I have a workbook that will be my main program. From this workbook I need to do the following in VBA. 1) Reference external workbook (hardcoded location). 2) Create arrays based on the sheet names in this external workbook 3) Populate each array with the table data in each worksheet once the...
  5. J

    How do I reference an external worksheet in VB?

    Hi I'm struggling to make some VB code reference an external workbook. I can't pick out the most suitable method from the other threads out there. I've created an 'Enquiry' worksheet which I plan to allow various users to open so that they can interrogate data held in another sheet. To make it...
  6. P

    Create Button from VBA

    I have a spreadsheet (A) that creates a new spreadsheet (B). I would like to incorporate some VBA code from Spreadsheet (A) that when Spreadsheet (B) is created, a button labeled "Show Data" would be created on Spreadsheet (B). Specifically speaking, I will have data in Column "E" that is...
  7. C

    VBA Q(s), a composite task mainly regarding External workbooks

    ​Hi all, First post. I do hope that I'm complying with the norms and terms and that my question is clear and not overly complicated. That out of the way... I'm clearly a beginner, using office 2010, tasked with (and so far failing miserably at) putting together some code for my new position. I...
  8. N

    Formula to reference external workbooks

    I have a workbook with three different columns and within each column are approx. 245 formulas. Each formula in a column references a workbook and each column has a different workbook that is referenced. The referenced workbook is labeled in row 3, such as A, AA, and AC all reference workbooks...
  9. B

    Using an IF function inside a macro to generate another macro

    Hi guys, this is quite a complex problem and seeing as I haven't used vba since I was in school I might be a little bit out of my league. I've designed two spreadsheets to monitor task counting where I work, one workbook for a daily analysis and another for monthly which we will be pasting...
  10. G

    Using DATA VALIDATION drop down to set workbook name in SUMPRODUCT

    Hi! I'm hoping someone can help me please. I have a formula in excel as follows: <code>=SUMPRODUCT(('[XXXXX.xlsx]01 04 2014'!$E$2:$E$922=C$7)+0) </code> I also have a data validation drop down in cell B2 that lists multiple client names. What I'd like todo is be able to use the drop down...
  11. 9tanstaafl9

    How do you copy data from another open workbook using VBA?

    Hello all! I want to copy data from an unknown tab on an unknown workbook into my workbook that will contain the macro that makes this happen. Is there a way to ask the user to click somewhere on the appropriate tab on the appropriate workbook and then capture that address to use elsewhere...
  12. L

    Vlookup with multiple IF Statements

    Hi all, I've got the following formula... =IF(ISTEXT(M6),VLOOKUP(M6,ContractHire!$B$2:$AE$999999,17,FALSE)," ") However I need to add some further conditions. H1 = 48 J1 = 10000 I need these conditions to match those in the external workbook. In simple terms - find line which matches M6, H1 &...
  13. G

    Change existing pivot table's data source to external workbook

    Hi there! I have a workbook with dozens of pivot tables defined, and their data sources are set to named ranges in various worksheets within the same workbook. Due to a change in customer requirements (don't you love those!), I now need to bust the detailed data out into separate workbooks...
  14. MrExcel

    VLOOKUP to External WB - entire table stored inside linking workbook

    Hello everyone - On a recent trip to California, I met up with some Excel people at a bar. Lots of great discussion :beerchug:, but one chap pointed out what seems like a security hole in Excel. I am passing it along here. WorkbookA has some employee ID. You link to WorkbookB, range A2:S99 to...
  15. V

    Copy Data From External Workbook Without Opening

    I would like to copy data from an external workbook and save it into my current workbook. There is plenty of code for this. What I have not found is how to do this without the external workbook ever opening. Is this possible and how would you do this? All I can see related to this is using the...
  16. T

    V-Lookup across multiple sheets on an external workbook

    Hello =VLOOKUP(A2,'[Item Master - Supplier Data.xls]Fit Scr'!$A$2:$I$558,2,FALSE) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Is there any way I can do a V-Lookup that searches over all sheets in a workbook rather than a specific sheet. In this...
  17. H

    Links to non-existent workbook magically work

    I have a workbook, workbook A, with lots of cells that link to a source workbook, workbook B. I copied workbook A from my hard drive at work to do some stuff at home, but I did not copy workbook B. I can't figure out how, but when I open workbook A (at home), the links to workbook B appear to...
  18. T

    Hide Worksheet in a Seperate Workbook

    I have an excel file that opens two seperate excel files, copies all the tabs from a pre-existing xls to a template xls, saves them both with new names and then closes both. Everything is working fine, except I need to delete a pre-existing worksheet in the original file and then hide the...
  19. E

    Activate other workbook

    Hello, After two days of googling (since om still a beginner) I have yet not found a solution to this (probably easy to solve) problem. I will firstly try to explain the problem and afterward the whole idea of the solution (if anyone wants to comment). I am trying to copy values from two...
  20. P

    Validating cell referenced data in external workbooks

    I'm building an excel report consolidating data from various other workbooks and worksheets using cell references ( i.e. =[Book2]Sheet1!$E$5). Since these referenced workbooks are built by an external organization, I'm concerned about formatting changing. I'm familiar with using "&B1&" in...

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