ws2

Hi - I'm using the code below to lookup data in Ws2 and place it in Ws1. Currently if the value in Ws1 Column A isn't found in Ws2 Column E it will put a "N" in Column P. How do I tweak it so that it only changes the cells in Column P when there is a match between Ws1 Column P and Ws2 Column...

Hi guys, i need help. I have a task and i dont want to use vlookup because it makes the process very slow. im looking for a purely VBA code for the task. here is the code: Sub get_current_status() Application.ScreenUpdating = False Sheets("Sending List").Select Dim Lastrow1...

The way my code currently works is like this: ws1 has multiple columns and rows of data. The first cell on every row in column A is the title. The titles are from a fixed selection (it's a drop down) which are determined by a list that is on ws2 ws2 has the list of titles, which is h3 until...

Hi, i have the following: Sub fg()Dim WB1 As Workbook, WB2 As Workbook Dim WS1 As Worksheet, WS2 As Worksheet file1 = Sheets("variables").Range("A1") myFile = "C:\Temp\1\" & file1 & ".xlsx" Set WB1 = ThisWorkbook Set WS1 = WB1.Sheets("Sheet1") Set WB2 = Workbooks.Open(myFile) Set WS2 =...

So I am using the below code and it works perfectly thanks to some help on here but I want to add a check so that if the row has data but the value of ws1 column G is empty then I want to get the value of ws1 G by using ws1 E as the reference and getting the value for G from ws2 column A. The...

Hello Forum, I use this code to copy data over from ws2 to ws1 when cell C3 is updated. From ws2 I need the data in column "H" (10) to copy to ws1 column "N" (13) and I cannot figure out how to make this addition. I tried adding in "sn(i, 13) = arr(x, 10)" But this does not work. Thank you...

I have a file that consistently reports "Excel was able to open the file by repairing or removing the unreadable content". I have narrowed it down to a single macro which runs, and it seems to only cause "damage" when the file is opened on a different computer (on the same LAN) from which the...

Hello..... I have code that works well to use a value in each row in a column in WS1 and compare it to a list of names in WS2 and if there is a match, put the value in WS2 A1 into Cell O of WS1 (offset 11 columns). What I want to do is make this an "OR" and compare to WS2 range A2:A14 OR WS2...

Hi there everyone. Hopefully an easy one :) I have the following code which I am using on another part of my macro (which might be helpful.. I think). Ultimately what I need to do, is copy columns A:J for any row where column L equals Not Exported. It will copy to sheet WS2, beginning on row...

I'm trying to compare columns of first and last names (A:B) on ws1 with columns (A:B) on ws2. If the name exists on ws2, then I need to copy the value of ws1 columns (I:L) to ws2 columns (D:G) for the matching row.

So some of you have already helped tremendously on this project, and it turned out great! I tested it live and I think I need to make a few changes as I found a few flaws in the design. And I am looking for some help. For example I have 3 main sheets (technically 7 as there is 5 days in the...

I'm trying to use the following code to find some dates (VLOOKUP) on a different worksheet and fix their values in place (Copy/PasteSpecial). Then the macro should look through the dates and clear them if they are in the future (> Date). This macro works, but the first time it's run after a...

Perhaps this is wishful thinking, but I'm looking for something that retrieves data similarly to a VLOOKUP function, but the resulting value would then become permanent. My example: I have a list of names on ws2, and an identical list of names on ws1, plus some extra outliers on ws1 that will...

I have 2 worksheets from 2 separate workbooks. For this question I will say Workbook 1 and worksheet 1 is called WB1 and WS1, the other is WB2 and WS2. On WB2, WS2, I want it to extrapolate row information from WB1, WS1 if it contains the word DV in Column A2-A117. I want it to pull info...

Hello, I use this macro to copy and Paste from WS1 to WS2. But I need it to copy and paste new data on the next row down on Ws2 When the button is selected. I cant figure this out. Thanks for all help provided. Sub ButtonCode() Dim ws1 As Worksheet, ws2 As Worksheet Dim DestRow As...

I'm trying to use VBA to insert and fill down a Match formula from S7 to the last row in column S on ws1, and the range of the Match formula should be A3 to the last row in column A on ws2. Here's what I have, and it sort of works, except that the resulting formula has a #REF ! error. I'm...

Worksheet 1 contains data I want to sort. WS2 contains relative cell references (=) to WS1. When I sort and filter WS1 the cell references in WS2 do not change so the data in WS2 is incorrect. How do I solve this please?

hello all I have this script which functions as expected, what I'd like accomplish prior to replacing the applicable values is highlight the values. unsure maybe stop at this point or continue to the replacement. Thanks as always Sub HighlightValues() Dim c As Range Dim k As Variant...

Hi again! <colgroup><col><col><col><col><col><col><col><col span="2"></colgroup><tbody> My formula isn't working as intended anymore. Here is what I wanted: I have 3 worksheets: WS1 WS2 WS3 WS4 Vendor name Expiry date Formula field Vendor name Vendor...

Hi everyone, I got lost trying to do a formula... Hope you can help me! I have 3 worksheets: <colgroup><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>...