Mystery line appearing in worksheet

[Bax]

Hi All,

Apologies for the inconclusive title, but not sure how to describe my problem...

Attached file has several tabs, "Overall sheet", "Pivot" and various data tabs (called "M68 xxxxxx").
These data tabs all have the same header (line 1). Starting from line 2 and below, data is filled in.
There is a macro in this file which pulls the data from these various tabs into the "Overall sheet".
It then checks for duplicate serialnumbers etc.

The problem starts when there is no data in the data tabs. Then in the "Overall sheet" the headers of these data tabs are shown for some odd reason. I can't figure out why it's shown there.

What I need is that when there is no data in the data tabs, the lines in the "Overall sheet" are empty.

Attached file has example data in the first 2 data tabs "M68 B661-4412" and "M68 B661-4697". The next 2 data tabs are empty.
You see in the "Overall sheet" that the data from the first 2 data tabs are copied as it should, but in line 12 and 13, I have the headers of the other 2 data tabs.
How can I adjust the macro so that these 2 lines are not shown?

Hopefully the above is clear, if not, just let me know!!

Thanks all in advance!!

Kind regards,
Peter
M68_2.xlsm

[Norie]

Peter

Check if there's any data before copying.

Please Login or Register  to view this content.

[Bax]

ah, perfect!! Thanks a million!

Star earned...

Regards,
Peter