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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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