Forum Discussion

jenjers's avatar
jenjers
Copper Contributor
Sep 02, 2022

FILTER function across multiple sheets, display in separate sheet

I have 3 spreadsheets labeled 'lesson 1', 'lesson 2', and 'lesson 3'. I made a 4th spreadsheet labeled 'planner sheet'. In the first cell in the 'planner sheet' I put the formula: ={FILTER('les...
Excel for web
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Sep 02, 2022

jenjers If you have access to VSTACK() function then could try.

 

=VSTACK(FILTER('Lesson 1'!B:Z,'Lesson 1'!A:A=WEEKNUM(TODAY())),FILTER('Lesson 2'!B:Z,'Lesson 2'!A:A=WEEKNUM(TODAY())),FILTER('Lesson 3'!B:Z,'Lesson 3'!A:A=WEEKNUM(TODAY())))

See the attached file.

 

Resources