cl.offset

  1. H

    Lookup Data in Sheet1 on Sheet2 or Sheet3 and Return Value

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

    Vlookup Alternative

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

    Help with adding comment from scripting dictionary item

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

    Date within a year from now

    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"...
  5. A

    Need to Match two or more rows values based on their ID in another cell

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

    Dictionary request

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

    Help with userform

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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top