U ushaanu Member Oct 28, 2014 #1 hi , I have some numbers of excel file in zip I need all excel file compile in one excel sheet all data of excel files in same format. thanks Anu
hi , I have some numbers of excel file in zip I need all excel file compile in one excel sheet all data of excel files in same format. thanks Anu
Marc L Excel Ninja Oct 28, 2014 #2 Hi, open each file and copy / paste to the destination workbook … Don't forget : Macro Recorder is a friend !
Hi, open each file and copy / paste to the destination workbook … Don't forget : Macro Recorder is a friend !