Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #602 Jul 1, 2012 www.energyefficientbuild.com.
user Roee Adler said:
Google Spreadsheet: aggregating rows from multiple sheets
In a single spreadsheet, I have several sheets containing data that is structured in the same way. I would like to create a new sheet that will dynamically include all the rows from several other sheets.
following is a solution using the VMERGE (custom written function by ahab) available in Script gallery from within Google spreadsheet
user Roee Adler said:
Google Spreadsheet: aggregating rows from multiple sheets
In a single spreadsheet, I have several sheets containing data that is structured in the same way. I would like to create a new sheet that will dynamically include all the rows from several other sheets.
I'll give an example. Say I have a spreadsheet that contains one sheet per weekday (SundaySheet, MondaySheet, etc). Each of those sheets has exactly the same columns (e.g. "Item", "Count", "Cost Per Item", "Total"). What I'd like to do is create a new sheet called "WholeWeekSheet", that'll include all the rows from all other sheets, such that if I add a row to one of the sheets it will automatically be added to this aggregated sheet.
Is that at all possible?
--------------------------------------------------------------------------------------------
following is a solution using the VMERGE (custom written function by ahab) available in Script gallery from within Google spreadsheet
No comments:
Post a Comment