Hi

I have run this macro and it is working fine. But there is blank row coming in consolidated sheet after sheet data. For example one workbook data is pasted in consolidated sheet and then one row left blank. Then second workbook data is pasted and then one row blank. There thirty row leave blank because thirty file to consolidate.

Seondly the formating of sheet is not proper way. Is there any way to consolidate the data as value so that cell size does not change.

Quote Originally Posted by rocky View Post
Thanks buddy, now it is working....