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
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