VBA - Save historical of cells input RRS feed

  • Question

  • Hello,

    I have to insert some values in the "P" and "Q" columns and I want that those values, that I am going to put in those cells several times, to repeat in the same row of the the values that i am goingtho insert.  

    How can i do this VBA code?

    I will explain my example:

    P Q S T U AA XFD
    Stock In Stock Out Historic In/Out STOCK
    Etiq A                  
    Etiq B                  
    Etiq C                  

    I am going to insert in cells "P" and "Q" several values of tags that are going to be in stock and out of stock in diferent days and I want to have the values of the In/out stock historical.

    The code that I need is something that can save my stock numbers in the cells from "S" to "XFD"

    Can you please help me with this?

    Thank you!


    Monday, June 17, 2019 5:01 PM

All replies

  • Hi, 

    This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Emi Zhang

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Tuesday, June 18, 2019 2:32 AM
  • Hello Emi Zhang,

    I am really strugling with this problem.

    Do you know someone that can help me with this?

    Thank you


    Tuesday, June 18, 2019 8:02 AM