Worksheet Change to update multiple cells

  • Hi, so I have a fairly basic problem that's the last link to a PM tool i've built.

    I have several cells in the same row with drop down lists. When an item is selected from the list I want to record the date in another cell in the same row.

    I've managed to get it working for the first cell, but the code doesn't any other cells.

    Here is my code:

    I will need to do this for 9 different ranges, Column G,I,K,M,O,Q,S,U,V.

    I wont be sleeping till I get this working for tomorrow, so any help would be SUPERR DUPER APPRECIATED <3

    Thanks in advance.

  • I fixed my code. Ended up using this, can wrap up this in a loop..

    This actually inputs the date in the right columns. Any insight to why I had to offset as minus and not plus?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!