ignore header row on blank worksheet on consolidate

Hi,

I am attempting to consolidate multiple worksheets into one. The consolidation works fine on worksheets that have data however, as in my example file, there are worksheets which are presently blank (empty of data) - save for the header row.

The problem:

On consolidation, the header row from the "Empty" worksheet becomes a row in the "master" worksheet that is created. How can a worksheet without data be ignored on consolidation?

Any help would be great. Thanks

You can skip importing by checking is worksheet empty or not!!

HTML Code: 

here ws refers to worksheet.

Cheers!!

Thank you in.vaibhav for putting me on the right path.

I managed to add this code which ignores the header row in my example

Please Login or Register  to view this content.