Meger multiple file but header not same

**rocky** · 10-25-2012, 01:08 PM

Thanks buddy, now it is working....

**rocky** · 10-25-2012, 03:29 PM

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.

Originally Posted by rocky

Thanks buddy, now it is working....

**Admin** · 10-25-2012, 08:07 PM

Hi

After the line 'Loop' insert the following line.

Code:

dest.EntireColumn.SpecialCells(4).EntireRow.Delete

also replace this line

Code:

.Range("a2:as" & j).Copy Dest

with

Code:

.Range("a2:as" & j).Copy
dest.PasteSpecial -4163
dest.PasteSpecial -4122

**rocky** · 10-25-2012, 08:58 PM

Hi

I am getting the following error again and again

There is large amount of information on the Clipboard. Do you want to be able to paste this information into another programe later.

To save it on the Clipboard so that you can paste it later, click Yes
To delete if from the Clipboard and free memory, click no.