Sep 19 2022 01:26 PM
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
Sep 19 2022 07:37 PM
@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;;