Combine data from multiple workbook/worsheets into a master file

[lakshmi.acharya]

Hi,

I'm using the macro code from the below post (Thank you!! Tom Urtis) and everything almost works the way I needed for just one small glitch.

http://www.mrexcel.com/forum/showthread.php?t=83597&page=2

This code copies data from each of the worksheet in the 'District' workbook into the respective worksheet in the Main workbook. When any worksheet in the 'District' workbook has no data and has just the header, the macro is copying the header row into the respective worksheet in the Main workbook; resulting in two rows of the same header. Interestingly, this works fine when there are other rows of data in the worksheet.

I think I need to change the code just a little to get what I want but being a novice at this, I'm having a hard time figuring it out. Any help that I can get will be much appreciated.

Thanks,
Lakshmi