Forum Discussion

Pcak9001's avatar
Pcak9001
Copper Contributor
Sep 19, 2022

I need some help

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...
excel
Harun24HR's avatar
Harun24HR
Silver Contributor
Sep 19, 2022

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