I want to merge 2+ spreadsheets (Eg: RESULTS206 and RESULTScdTi) from same workbook into 1 worksheet (MULTI-RESULTS).
Sample spreadsheet www.srands.co.uk/exoftable6.xls
Note: RESULTS206 and RESULTScdTi are sort's of WORKSHEET1, then I want a MULTI-RESULTS of all RESULTS spreadsheets.
Each spreadsheet has a named range, and the code I've entered for each of their defined name range's per RESULTS spreadsheet is:
=OFFSET($A$1,0,0,COUNTA($A:$A),1)
This code expands down as Many Rows as There are Numeric and Text Entries.
Then to combine/merge all of the spreadsheets into 1 spreadsheet, copying row by row, of each RESULTS spreadsheet, TO EDIT
:
=OFFSET(RESULTS206!A2,0,0,COUNTA(RESULTS206!A:A),1)
=OFFSET(RESULTScdTi!A2,0,0,COUNTA(RESULTScdTi!A:A),1)
What is the right code to combine the 2 formulas above into a 1 cell formula, that works? Sample spreadsheet: www.srands.co.uk/exoftable6.xls
Guess this is straight forward, can't find any decent obvious examples, odd as surely many people encounter something like this on a daily basis.
What I tried already:
~ Pivot tables, the summary of figures is NOT what I need.
~ VBA code I've tried, was not of any use, as would only copy&paste raw text and/or number, not formula generated data.
~ RDBmerge merging doesn't provide the solution I need.
~ Data, Consolidate does NOT work with words and text, only numbers.
Sample spreadsheet www.srands.co.uk/exoftable6.xls
Note: RESULTS206 and RESULTScdTi are sort's of WORKSHEET1, then I want a MULTI-RESULTS of all RESULTS spreadsheets.
Each spreadsheet has a named range, and the code I've entered for each of their defined name range's per RESULTS spreadsheet is:
=OFFSET($A$1,0,0,COUNTA($A:$A),1)
This code expands down as Many Rows as There are Numeric and Text Entries.
Then to combine/merge all of the spreadsheets into 1 spreadsheet, copying row by row, of each RESULTS spreadsheet, TO EDIT
:=OFFSET(RESULTS206!A2,0,0,COUNTA(RESULTS206!A:A),1)
=OFFSET(RESULTScdTi!A2,0,0,COUNTA(RESULTScdTi!A:A),1)
What is the right code to combine the 2 formulas above into a 1 cell formula, that works?
Sample spreadsheet: www.srands.co.uk/exoftable6.xls Guess this is straight forward, can't find any decent obvious examples, odd as surely many people encounter something like this on a daily basis.
What I tried already
:~ Pivot tables, the summary of figures is NOT what I need.
~ VBA code I've tried, was not of any use, as would only copy&paste raw text and/or number, not formula generated data.
~ RDBmerge merging doesn't provide the solution I need.
~ Data, Consolidate does NOT work with words and text, only numbers.
