Consulting

Results 1 to 2 of 2

Thread: Help with VBA Code: cell values and matching values

  1. #1

    Help with VBA Code: cell values and matching values

    Basically, I want to compare the value of a cell with a whole column.

    I want to start comparing the first cell with the first cell in the column. If all 4 digits match, then I want to print that value in a separate cell. If only the first 3 digits match, I want to print that value and times it by 10. If only two digits match, I want to start comparing that cell with the next cell down in the column. I want to continue this process until either the cell finds a "match" or there is nothing left in the column to compare to.

    I don't really know how to do this. Let's say the first cell I want to compare is C15, and the column is right next to it from D15 : D75. How would I form this code in VBA? Once I'm done comparing the first cell to the entire column, I would also like to move down and continue on with the process. What I mean is move down to cell C16, and then compare that cell to the entire column from D15 : D75. Thank you!

  2. #2
    VBAX Newbie
    Joined
    Jul 2018
    Location
    Essex
    Posts
    3
    Location
    Are you really looking for a solution to this using ACCESS ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •