• 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


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

Update Table Value from the cell value, Cell value = "FY XX_YY"

Anshum Manocha

New Member
Hello Everyone,

I need a little help, i have multiple F.Y data, and i need to update the data with the cell value, like if i enter cell value A1= "2018-19", i need values from A3:F10 changed from the table name "Table2018_19" or Sheet2 naming "2018_19", if cell A1 value changes from "2018-19" to "2019-20" the the A3:F10 value Changes from the table name "Table2019_20" or sheet3 name "2019_20", and so on.

Please help me out, and i am updating sample files because the data i have consist of 9000 cell values per table