workbook1

  1. A

    VBA Copy columns with non-similar header name between two workbooks

    Hi there, how can i make a condition to copy then insert a column to another workbook, the only condition is that, if this columnd header exists in the current workbook dont copy it ! EXAMPLE: workbook1 <tbody> Name Age City Email </tbody> Workbook2 <tbody> Name Title Age...
  2. W

    VBA script for conditional copy, format & paste from workbook1 to workbook2

    <tbody> In workBook1, i have five columns (A,B,C,D,E) with data. Here, each row is a separate record & is going have unique data. sample data is given below. A B C D E 1 Q1 A1 A2 A3 A4 2 Q2 B1 B2 B3 B4 <tbody> In workBook1, when i...
  3. W

    Application.ThisCell and CalculateFullRebuild

    I have been having some trouble using Application.ThisCell and need some help. To explain the issue, I created some simple code. There are two workbooks. In each one, I have the following UDF in a module. Function CalcIt(ByVal x As Variant) CalcIt = Application.ThisCell.Column &...
  4. P

    Copy only texts and values only but not formulas from one workbook to another

    Is there a macro that copies only text and values but leaves the formulas in their cells when copying ranges from one workbook to another? Some ranges have formula in them but I do not want to copy them from one workbook to another. ODIN was kind enough to send me the code that copies...
  5. P

    Copying a formula from one Excel worbook to another Excel workbook

    I recorded a macro that copies a formula from workbook1 to workbook2. When I checked the formula in workbook2, I noticed that it had the reference to workbook1. I do not want the formula in workbook2 to reference workbook1 in the formula. Is there a way to avoid referencing workbook1 in the...
  6. L

    moving/copying a sheet from one workbook to another

    Hi I can move/copy a sheet from Workbook1 to Workbook2, if Workbook2 was opened/created from Workbook1 by going to File-->New. However, if I created Workbook2 by going to windows start menu-->Excel then, I wont be able to copy/move a sheet from Workbook1 to Workbook2. Why is that and how can I...
  7. E

    Copy row information one workbook to another

    Hello, I have two workbooks. Workbook1 and Workbook2 I would like Workbook2 to look for only my dogs name in Workbook1, cell C6 then once is name is found pull all the corresponding row information from A1 to H1 then paste it into Workbook2, cell A1 to H1. I there a formula for this? VLookup...
  8. P

    Copy - pasting macro

    Hi there I have 2 workbooks opened at the same time. Lets call them workbook1 and worbook2. I have workbook1 opened and I recorded a macro. In workbook1 I copy the range A2:H158 into workbook2 Here is a partial recorded code Range("A2:H158").Select Selection.Copy...
  9. C

    Delete row base on other sheet

    For each cell in workbook1 colum "A" i would like to compare that against a list stored in workbook2 and if it is found delete the entire row from workbook 1. Additionally for the #'s in workbook2 if they do not exist in workbook1 delete that cell from workbook2. Also workbook2 would notrmally...
  10. H

    Activating workbook from userform

    Hi I am loading a userform from workbook1 which contains code behind a command button to select another workbook (workbook2) and load it. I want the active workbook to be workbook1 but despite activating this workbook the active workbook remains workbook2 If after loading workbook2 I use...
  11. L

    vlookup - 2 files and then delete the second one

    Hi I have name, dept, and salary in workbook1 and name, and phone # in workbook2. I used vlookup function to find phone number and put it in workbook1. Everything worked fine. I deleted workbook2 and to my surprised the vlookup function still returning the right phone number? Why is that? did...
  12. L

    moving a sheet from one workbook to another - but keep the original one

    Hi I wrote a code to move a sheet from one workbook to another, please see below. It did work but it will move from workbook1 to workbook2. Can I move it and keep the copy in the workbook1. Same as if i do it manually by pressing CTRL and drag and drop the sheet. Thanks you so much. Sub...
  13. L

    Compare values in 2 different columns in 2 different workbooks and list differences

    I have workbook1 column b that contains shipping numbers and I need to compare it to workbook2 column c which also has shipping numbers. Basically we are trying to ensure that the shipping numbers in workbook1 column b are contained in workbook2 column c and match exactly. If not, then we need...
  14. P

    How to look at last modified workbook and copy data to the new Workbook

    I'm going to try to explain the best I can! I have an excel open (Workbook1) currently. There are part numbers in Column A. I need a VBA to go to a folder named "Pipe" on my desktop and open the Last Modified file(Workbook2). Once open the VBA needs to go to the "Workbook1" and create a new...
  15. S

    Move rows from one sheet in a workbook to another workbook

    Hi all, I have a workbook1 with a single sheet containing multiple rows of data. I need to create another workbook2 with each sheet consisting one row from workbook1. To be more clear one row from workbook1 should be contained In one single sheet in workbook2. If suppose workbook1 has 20 rows...
  16. H

    Run a Marco in another workbook

    Hi - I have workbook1 that i'm running macros in. One of those macros brings over data from workbook 2. Workbook2 has it's own macros. Is it possible to put code into workbook1 that will run a macro in workbook2 before bringing over the data? Meaning workbook2 has a macro called "Update" can...
  17. I

    How to tie Userform to only 1 workbook

    I've created a user form that uses multiple sheets in my workbook (workbook1). I want the user form to only access that specific workbook. But, when I open a different workbook (workbook2), the user form changes data in workbook2 instead of workbook1. It is changing data in whatever workbook is...
  18. E

    Reference different workbooks and sum the individual values

    I have a table in a worksheet (named "stock list") with 5 columns in a workbook I will call Workbook1 and in other workbooks with identical tables. The last column in workbook1 named "Total" is gotten by summing the "Totals" from the external workbooks. These external data sources are saved as...
  19. K

    Summing data from different workbook with multiple worksheets

    I have a workbook (workbook1) to track hours. In this workbook are multiple worksheets for the different months. Each worksheet will have multiple dates with multiple clients and the hours work for them. The name of workbook1 does not change. In a separate workbook (workbook2) I am tracking the...
  20. L

    Copy data from one workbook to another based on the sheet name and column name

    Hi, Column A of Sheet 1 in the first workbook(1) contains the worksheet names that correspond to a second workbook(2)'s worksheet names. Row 1 of Sheet 1 in workbook(1) contains the names of each column. Row 1 of each worksheet in workbook(2) also contain the names of the columns but they are...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top