Copy data from multiple workbooks into summary tool workbook

[Thomas Kuriakose]

Respected Sirs,

Kindly find attached the summary workbook after running the macro. It has copied blank cells data also.

It has gone to all the workbooks in the directory and copied data with one click of a button. This is very good.

The cells where D to I is blank should not get copied. But there are instances of copy of blank rows.

However not to miss out on any workbook, can we get the look in prompt and select the workbook individually.

I attach a workbook of the desired result after deleting the blank rows for your reference. I have not changed the serial numbers (Column A) to show how many rows are deleted in between.

Thanks,

with regards,
thomas

 

[Marc L]

My code is the result of your answer :​

Respected Sirs,

2) at least one cell must be filled to copy row ?
Yes

So it's your bad !
​

The cells where D to I is blank should not get copied. But there are instances of copy of blank rows.

There is no D to I blank row in my demonstration result ‼
Because of your answer : at least one cell filled …

After having a look of your desired result workbook,
criterias are not obvious !

So, as yet required :​

explain which B to I columns must be filled and which could be blank
to allow a source row to be pasted in summary workbook …

You could amend my demonstration by updating P2 cell criteria formula …
For example instead of at least one cell filled with P2 formula >0
try >1 to copy row with at least 2 cells filled …

I can't test anymore with the poor P1.xlsx sample
'cause your result wasn't upon this workbook …
​

 

[vletm]

@Thomas Kuriakose
I hope that I found the answer for You, 'Which rows should copy?'
You can select 'which of those columns' Yourself before 'Start'!
There are also few more options to select.
Test it!

 

[Thomas Kuriakose]

Respected Sirs,

Thank you very much for all the support extended in the code for this problem.

Thank you so much once again.

with regards,
thomas