Class 38: Consolidate Copy

Summary: In this video, Mr. Raj Singh Sir will teach you how to use CONSOLIDATE Formula. We will learn how to take data from two different sheets and post it on a single main sheet. Any changes made in the other sheets will be reflected in the main sheets.

Process: Click on the DATA TAB > then go on CONSOLIDATE (FUNCTION, REFERENCE, AND ALL REFERENCE)

Tick all the checkboxes below

Conclusion: In this video, you learned how to make a Master sheet out of many sheets.