Data Tab…Consolidate [Data Tools]…Select FX…Add Ranges…Select Options…DONE!
Today’s Excel Q&A by Philip Gamey, shows you how to use Excel’s Consolidate tool to unite several reports.
Watch the video below: