Macro for consolidate multiple workbooks in one worksheet

hello all,

thanks in advance for answering this problem..

now come to problem 

i have to consolidate excel worbooks in one new master excel worksheet (in one worksheet)

my range is from A6:BG and upto the last

and all excel file is located in te same folder so please help me to consolidate all the data 

this work is to lenthy to go through manually

so i think macro is good substitute for it

By: Rishabh

Leave a Reply

Your email address will not be published. Required fields are marked *