• 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

    Hui...

  • 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
 

Attachments

AliGW

Active Member
In A6 copied across and down:

=INDIRECT(SUBSTITUTE($A$1,"-","_")&"!"&CELL("address",A2))
 

bosco_yip

Excel Ninja
Another A6 copy across down formula option :

=INDIRECT(SUBSTITUTE($A$1,"-","_")&"!R"&ROW(A2)&"C",)

Regards
 
Top