Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel assistance required

  • 10-09-2020 02:18PM
    #1
    water-man
    Registered Users, Registered Users 2 Posts: 285 ✭✭


    Hello,

    Hoping this is the right forum to post in.

    I'm looking for a little pointer on excel. I'm trying to make a macro that will do the following automatically:

    Cell A1 - Enter a customer ID
    Cell B1 - Enter expected delivery date

    I want to run a search that will:
      take the customer ID in cell A1
      search all of column B
      Once it finds the customer ID in Cell B{i} (where "i" can be any row number) paste the "expected delivery date" info from Cell B1 in cell G{i}

    The first 2 parts are simple however how do I do the third part?

    Thanks,

    WM


Comments

  • #2
    water-man
    Registered Users, Registered Users 2 Posts: 285 ✭✭water-man


    Think I might have a solution to my question.

    I need to set up a loop that starts in cell B{i} where on first run i = 4. And then do a check to see if Cell B{i} = cell A1. If not increase i by 1 and repeat.

    EDIT:

    It worked. Case closed.


Advertisement