1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy from Dynamic column cell value to Static cell

Discussion in 'VBA Macros' started by Vijayarc, Jul 11, 2018.

  1. Vijayarc

    Vijayarc Member

    Hi Team,
    As per my attached sheet,the columns are dynamic, adding one column on daily basis when button click
    i want the dynamic data to save to next sheet on fixed cell
    for example: dynamic cell value :BE3 should save on sheet2 on B2 static cell
    :BE4 cell should save on sheet2 on B3 static cell ...........so on

    please help!!!! thanks in Advance

    Attached Files:

  2. Luke M

    Luke M Excel Ninja

    Looks like you just want to grab the last number from each row. A quick LOOKUP function will be your best route. In B3 of Sheet2, put this formula:
    =LOOKUP(9E99, 'Sheet1'!3:3)

    In B4, something similar:
    =LOOKUP(9E99, 'Sheet1'!4:4)

    In D3
    =LOOKUP(9E99, 'Sheet1'!11:11)

    Vijayarc and Thomas Kuriakose like this.
  3. Vijayarc

    Vijayarc Member

    Thanks Luke, u solved in simple Lookup.
    wowww... Thanks for Help!!!!!!!!

Share This Page