different workbooks

  1. S

    Need help with vba code to copy/past loop in different workbooks

    Hello! I've just started working with vba and have some difficulties with a code to copy and paste. I have 2 workbooks, the first one is called months and the second summary. In months there is a worksheet for each month (JAN, FEB, ...) and every month some rows of a table (B3: E15) are filled...
  2. S

    VBA code to copy/past a table to different workbooks

    Hello! I've just started working with vba and have some difficulties with a code to copy and paste. I have 2 workbooks, the first one is called months and the second summary. In months there is a worksheet for each month (JAN, FEB, ...) and every month some rows of a table (B3: E15) are filled...
  3. B

    Copy values from another workbook based on div. criteria

    Hi, I am looking for a VBA solution for the following problematic: I have one Master file and want to collect data from about 20 different excel workbooks (slave workbooks). The Master file consists of the following 13 sheets: "Home", "Jan 2018 Overview", "Feb 2018 Overview" , ... , "Dec 2018...
  4. K

    Running macros from multiple workbooks

    I have two workbooks with two different macros. How do I run a macro from workbook1 then go to workbook2 to run the second macro without having to click through different workbooks? First Macro, allows you to open a file and copy and paste information based on column header. Second Macro...
  5. I

    Collate selective columns from multiple workbooks

    Hi All, I have 18 different workbooks saved in 1 folder (Workbook 1, Workbook 2, Workbook 3 etc) with the same worksheet names (Sheet 1, Sheet 2, Sheet 3 and Sheet 4), in all the 18 workbooks. I need to collate the data in Sheet 2 of all the 18 workbooks Sheet 2 of all the 18 workbooks has...
  6. U

    Creating a hyperlink from textbox content

    Hi guys, I have created a userform that sends its content to the active workbook (lets call it workbook A) then sends it to another workbook (Workbook B. What I want to do is to add a hyperlink in Workbook B that refers to Workbook A so that the readers easily can trace their way back. My code...
  7. M

    VBA code working in one workbook but not another

    Hi I apologise if this has already been solved somewhere on this forum, however I am unable to find it. I have two workbooks in which I am trying to use the same code. In one it is working but in the other it is not. I am using Excel 2007. Here is the code: Option Explicit ' Developed by...
  8. T

    Merge data from 2 Excel WB into one - exact same header, same data column format - need VBA

    Merge WB2 data into WB1 then delete WB2. The process creates 2 excel files via CSV, so they are exactly the same format, same exact header. Each workbook has 1 tab. The two Excel Workbooks are in one folder WB1, WB2 - always named the exact same. Need to open WB2, copy all but the header...
  9. J

    Pulling Data from a different workbook and dividing by more data from that workbook into a new workbook

    Hi. This is my 1st post in a forum...so bear with me please. I need help! I need to pull data to a new workbook from a single cell in a range of sheets out of an existing workbook and divide it by another cell in that same range of sheets from that workbook. I have looked and the closest...
  10. T

    Paste value from one workbook to another

    hi, I am looking to paste a value from one workbook to another. When cell A2 = "A Value X" in workbook 1 I want it to copy the value from cell E6 and paste this into the workbook 2. The value should be pasted in the last empty row of the columnA containing the "A Value X" in workbook 2...
  11. L

    VLOOKUP with INDIRECT: The name of the Workbook i want my VLOOKUP to work on is given in a cell.

    Hello everyone, I'm trying to use VLOOKUP to search on a table in a different Workbook (which is also open, say Workbook 2.xlsx on it's Sheet 1) than the current (say Workbook 1.xlsx). I want to write the name "Workbook 2.xlsx" in a cell of Workbook 1.xlsx Sheet 2 and then just use INDIRECT to...
  12. J

    Help with If function between work books please?

    Hi, I am trying to work out a formula without much luck so wondered if anyone could help please? Basically, I have 2 work books one (request data) to feed from and another (request M.I) to report weekly. They are both in different folders. So in Request Data I have - Column A...
  13. S

    Vlookup in different workbooks, used for email address

    Dim ws As Worksheet Dim vFilePath As String Dim CurrentFile As String Dim Cellname As String Dim vTable As String Dim OutApp As Object Dim OutMail As Object Dim OutNS As Object Dim EmailTo As String Dim EmailCC As String Dim EmailSub As String Dim...
  14. N

    VBA Code to collate data from a nr of s/s and insert in one s/s

    Each month I get circa 30 workbooks with cost data in, split by tabs in to cost heads, such as; Staff, Materials, Plant, Subcontract ...etc. I need to collate all the cost data for each cost head into one workbook (that is a separate workbook for each cost head). At the moment this is...
  15. T

    Import unique values from another Workbook AND import dependant conditional values

    Hi All. I would like to import uniqe values from a list in workbook (MFL) into another workbook (FieldValues), in a sheet that shall be used for validations. I've been looking at different load scripts but haven't really managed to sort it out. A button that triggers this macro would do the...
  16. M

    VBA Macro calling different workbooks

    Whats up fellow excelians, I am somewhat new to VBA and excel and have a question that may test the mite and knowledge of every member to this site. My end result goal is to write a macro that will take the contents of a cell in one workbook and uses that input to find a file name matching...

Some videos you may like

This Week's Hot Topics

Top