cl.offset

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

I'm using this code, although I've amended it a bit and one of the things that I want to do is to get it to add a comment in to a cell With CreateObject("scripting.dictionary") For Each Cl In Ws2.Range("A2", Ws2.Range("A" & Rows.Count).End(xlUp)) If Not...

Hi all, I've had a search but I can't really find what I'm trying to do..... I'm running through cells and I want to only use cells that have a date within the next year The code I have is this: With CreateObject("scripting.dictionary") For Each cl In Ws2.Range("A10", Ws2.Range("A"...

Hi Can any one help me on below code:- first check that how many cells or times one/same id contains and then match and color code (if matches then green else yellow) company name with the similar times.Below is the code given in this forum but it not working properly- [CODE] [Sub...

Hello Friends! One of our Moderators - Fluff - is providing Dictinaries which speeds up everything beyond expectations. Can You make for me a macro that will compare colums A,E,G and remove duplicates in this fashion? ex. IF A5, E5, G5 has the same values as A54321, E54321, G54321 and A99...

Hi guy thanks for taking the time to look at this and any help given. I have a contact form that works well but what I am trying to do is on this form is, there are 2 multipages 1 for sites (multipage2) and 1 for lifts (multipage 3) and I want these to update depending on customer ref but also...