Results 1 to 3 of 3

Thread: Locate Sets of Numbers

  1. #1
    Acolyte mike guest98's Avatar
    Join Date
    Jun 2018
    Posts
    28
    Articles
    0
    Excel Version
    2010

    Locate Sets of Numbers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need help with new code. There is lots of code to “FIND” but I can’t find anything that writes the cell location of the FIND to specified cells. I can’t use a formula because it will be running with other code.

    Using my sample Excel sheet I need code to locate any set of numbers (1-1, 9-9, 20-1 etc.) in the range A3:A35, D9:D25 (need to be able to add additional ranges as needed). In my actual sheet there is data above all these sets of numbers.

    Sample data is finding 1-1 in cell A3. Using the first number of the set, 1, the code would then search the range G3:G20 for a 1 (please make this cell location changeable) and then write the cell location in the 3rd cell to the right of it G3, so in cell J3 there would be A3. The second example 9-9 found in cell D9 would write D9 in cell J11 (using the first number 9 as the search).

    The set of number cells are formatted as text. The sheet number is 2. Using Office 2007.

    That would do it. Thanks so much for all your help.
    Attached Files Attached Files
    Last edited by p45cal; 2019-06-06 at 12:57 PM. Reason: disabled smilies

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,551
    Articles
    0
    Excel Version
    365
    Click button in attached.
    Attached Files Attached Files

  3. #3
    Acolyte mike guest98's Avatar
    Join Date
    Jun 2018
    Posts
    28
    Articles
    0
    Excel Version
    2010
    Thanks so much. This might work.

Posting Permissions

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