naridox
New member
Good afternoon, XGuru!
I'm building a dashboard populated via if/then statements ranging across 52 other worksheets (representing the 52 weeks in a year). Each week-based worksheet is titled "Wk ##." Rather than input if/then statements for 52 separate worksheets, I'd rather be able to make an indirect reference with a wildcard in the worksheet name to encompass ALL the sheets with "Wk" in the name.
=SUMIFS(INDIRECT("'Wk"&"*"&"'!$C:$C"),G3 ...
Or
=SUMIFS(INDIRECT("'Wk "&"?"&"'!$C:$C"),G3 ...
Is there a way to add a * or ? wildcard into the worksheet name, itself, in an indirect formula? It seemed to work for a moment when I had one worksheet name "Wk 1" with a wildcard reference of "Wk "&"*"& ... But once I added a second sheet, errored out.
Thank you!
Christian
I'm building a dashboard populated via if/then statements ranging across 52 other worksheets (representing the 52 weeks in a year). Each week-based worksheet is titled "Wk ##." Rather than input if/then statements for 52 separate worksheets, I'd rather be able to make an indirect reference with a wildcard in the worksheet name to encompass ALL the sheets with "Wk" in the name.
=SUMIFS(INDIRECT("'Wk"&"*"&"'!$C:$C"),G3 ...
Or
=SUMIFS(INDIRECT("'Wk "&"?"&"'!$C:$C"),G3 ...
Is there a way to add a * or ? wildcard into the worksheet name, itself, in an indirect formula? It seemed to work for a moment when I had one worksheet name "Wk 1" with a wildcard reference of "Wk "&"*"& ... But once I added a second sheet, errored out.
Thank you!
Christian