wb2

Hi, good morning, i have the code below but i was wondering if there was anything that could be done to make it abit more compact? also is there anyway to stop the pop up of the file? Private Sub CommandButton1_Click() Application.ScreenUpdating = False Dim lookuprng As Range Set wb1 =...

Hi, Following code is adding workbook (wb2) and add worksheet subsequently. Copy data from Wb1 and paste in Wb2 in added new worksheet but not able to paste format of wb1. Please make changes in following code to simplify it as well. Highly appreciate your help. Sub Summary() Dim...

I’m looking for a formula (Or how to) to locate the same record that is on one workbook and show on another workbook. On workbook one, I enter a customer by the Customer (ID) Number. On workbook two, I have customer numbers saved in columns. I am looking to have it so that when I enter a...

Hi again everyone, Q: what's the most efficient way to search for partial matches and populate results? I'm fairly beginner at vba but learning quickly. I have two very disorganized workbooks. Wb2 is where I will make all my edits. each workbook when exported has varying lines of code...

i have two different workbooks and would like to copy & past from one to the other if certain data in one worksheet matches the other. If data in column A wb1 matches data in column A wb2 on wb1 column D will return the value of wb2 column D workbook 1...

hi Everyone, I have two different Excel Workbook i.e. WB1 and WB2. I need to update particular column in WB1 from WB2. For example:- there are some common columns in both WBs (Sr no and Lifds Date). if I update Lifds date with same Sr No in WB2, then that date should be getting updated...

Hi, I have a setup of two workbooks (WB1 & WB2) where WB1 contains my UserForm and WB2 contains the master data. As it stands, when you open WB1 it automatically loads the UserForm using the below code, however, I would like to option of using a command button in WB2 to change the UserForm...

I have two workbooks, one is WB1 and second is WB2.With VBA I want to copy specific cells based on a IF condition from WB2 and double paste to WB1. Also I want to add some defined numbers into WB1. It should look like this: WB2...

Hello All, Hoping someone can help me out as i have been unable to figure this out and google searches haven't turned up anything for me. I have a protected workbook(wb1) with forms and associated vba code. The workbook opens other protected workbooks(wb2) and allows users to perform certain...

Hi,. I have this and it fails at the paste for "Subscript out of range". It would seem I am not properly selecting my destination. Is it my method? Sub Macro2() ' ' Macro2 Macro Dim wb1 As Excel.Workbook 'Open PSSLA workbook first Set wb1 = ThisWorkbook Dim wb2 As String 'Open Raw Data...

I have two workbooks within the same instance of Excel, wb1 and wb2. wb1 has this code in ThisWorkbook: Private Sub Workbook_Activate() Application.IgnoreRemoteRequests = True End Sub If I go to wb2 and copy the contents of a cell and try to paste it into wb1, nothing gets pasted...

Hi all, I am writing a macro that has to open another workbook (wb2), run a macro in wb2, copy some data and paste it to the first workbook. However, given it takes some time for Application.Run to actually populate the excel cells in wb2, it seems like the macro i am writing selects the range...

Hi, Experts Thanks in advance for your respond I need a VBA code to perform the below task Active workbook1 .xlsm - to random selective range of cells with Live formula to Copy Paste Value to WB2 on Cell: C19 and save it as new file .xlxs (file name VALUE AT CELL C20 and date DD-MM-YYYY)...

Hello, Not sure if im being dim, or this isnt possible. Here is my scenario: 1 have an active workbook /dashboard (lets call it wb1) I need to duplicate a sheet from a closed workbook (Lets call it wb2) so that I can process its data wb2 has macros and a popup message box when opening. Once...