↻ Back to Origin/OriginPro Videos

How to Collect Data From Multiple Sheets into One Summary Sheet

Range notation is used to refer to book, sheet, column and cell. User can put book, sheet, column and row info. in column or column label rows, and then concatenate these info. as strings to build range string, and prefix with == in cell formula to collect data from different books, sheets, columns and rows.

Origin Version:

Download MP4 File: ⇩ MP4

Watch on  
Watch on YouTube!

Last Update:11/29/2023