workbook1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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