add Today's date to next available column and populate values

  • In sheet "in Stock Inventory" have inventory listed in A2:A28 and I have dates in Row A starting in column 2. I have created a drop down in sheet "Log Incoming" that populates cell E9 and quantity in F9. I'm looking to create a code to put today's date if not already in the column then populate the row beside item in column A and under the current date with item showing in cell E9 with the quantity in F9.
    Please note that I'm new with VBA. Underneath is what "in stock inventory" looks like. I've also attached a screen shot. Thank you in advance

    A B
    3-Stop the drop-card
    4- Hardhat-Navy
    5- Winter Roper Gloves

Participate now!

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