I need some help

Occasional Visitor

I want  to  make  a year table   which  have  a template. 
I can made  the tables  but this  is  what  i want to  have

Ayt year   i want to make valdidation filed  with the years
So when i touch the 2022  in the template the year that  i  selected  needs to  be loaded  from the  workspace 2022 and  be loaded.
there is no such info  to  find this how to do  Jaaroverzichten / Year 

1 Reply

@Pcak9001 You can try indirect formula then use custom cell formatting to hide zero values. See the attached file.

=INDIRECT("'"&B2&"'!A5:N35")

Custom cell formatting

0;;