I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates itself and adds the new data every time a new entry is made to either one of the 2 base sheets.
So pretty much:
"f_clc_2014" is the first sheet
"f_vina_2014" is the second one
"combined" would be the merged sheet
Is this too complicated to do with formulas? Or is there a way to do it with a dynamic table?