Scope of the project:
Various size Excel files - only number of rows varies - need to be combined into one workbook. It would be helpful if an application could check for duplicate ID entries and return a list with values (DON`T need to delete). We would prefer to create a macro, we will consider different solutions. At times, we will combine ~300 files. Please feel free to contact us with any questions or suggestions. Thanks.
Tech specs: PC computer - Windows 7, 64-bit OS; MS Excel 2010.