[INDENT]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 [Blocked Image: http://www.excelforum.com/images/smilies/smile.gif]:**=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.

CROSSTHREAD(S):

http://www.mrexcel.com/forum/showthread.php?t=632777

http://www.excelforum.com/exce…ges-into-1-worksheet.html[/INDENT]