Unanswered: Macro to consolidate records from several excel files into 1 excel file
I need to consolidate the records of several excel files (same format) into 1 excel file. If a dos command is not possible to achieve this, I'm thinking of using a macro. But i haven't done macro programming before. How will i do this? Pls. help.