Merge/Consolidate spreadsheets with same headings INTO 1 spreadsheet, same workbook

    In my sample file http://www.srands.co.uk/exoftable5.xls 300kb


    2 Spreadsheets RESULTS P 206 and RESULTS H CDTI,have identical headings, all non-blank rows need merging / consolidating within the prepared 4th spreadsheet 'MULTI-RESULTS'.


    The data in the 2 spreadsheets will change, depending on the information available.


    However the consolidating feature of excel, excludes text/word entries (So sayes MicroSoft), the vba codes I've tried don't work, and the RDB solution isn't what I need.

    Re: Merge/Consolidate spreadsheets with same headings INTO 1 spreadsheet, same workbo


    srands,


    You've been around long enough to know that cross-posting is in violation of Rule 3 (refer here) of OzGrid's posting rules. Not sure why you didn't just provide a link back to MrExcel as you did there for OzGrid :confused:


    In any case, as Smitty seems to have taken up the task at MrExcel which this thread is cross-posted to (refer here) I've closed this thread.


    Robert

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login