rows.count.endxlup

Not sure where this is wrong , but... The below only puts new data on Row 35. If Row 35 has data, it will simply write over it. Where am I wrong? This is making me crazy! Currently there is data on Rows 2 and 3 and then nothing until 35. Row 1 is the header Row... Public Sub PDMRA_Copy() Dim...

Hi - How do I lookup an item on 2 lists with out the ws3 overriding the ws2 inputs? basically changing it so that if it cant find the item from ws1 in ws2, then look in ws3. This is the code I tried to modify to add ws3. thanks! With CreateObject("scripting.dictionary") .CompareMode = 1 For...

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

looking to Split Data in Column A into column b and column c. the below removes the text to the left of the coma. Thanks Sub SplitComma() Dim d As Range For Each d In Range("A2", Range("A" & Rows.Count).End(xlUp)) d.Value = Split(d.Value, ", ")(1) Next d End Sub

Hi, I have this formula, but i would like to just have in "K" the sum of offset(0,3)+offset(0,4) is it possible on VBA or should i add up that on the sheet and just copy it? Rw = 11 With Sheets("Draft") For Each Cl In .Range("K7", .Range("K" & Rows.Count).End(xlUp)) If Cl.Value =...

https://www.mrexcel.com/forum/excel-questions/1054389-compare-two-column.html Based off of the thread above, how do I get the code to highlight both columns if they do not match. mumps code: Sub CompareLists() Application.ScreenUpdating = False Dim Rng As Range, RngList As Object...