Sunday, July 1, 2012

yogi_Merge Data Form Various Weekday Sheets Into A Single WholeWeekSheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #602   Jul 1, 2012

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