Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Copper Contributor

Apr 07, 2023

Summarizing Data From Multiple Worksheets

[ Spoiler ]

Formulas and Functions

MVP

Apr 07, 2023

Use the INDIRECT function:

=INDIRECT("'"&A5&"'!B16")

Ron_Sloane
Copper Contributor
Apr 07, 2023
HansVogelaar THANK YOU!!!

Resources