Copy entire row if cell is not empty - VBA

[pantakos]

Hello,

There is a need to copy contents from a sheet if the value of a specific cell is NOT 0 or it is blank.
Need to copy the entire row and its contents to another sheet. Basically need to create rows in target sheet and not overwriten them.
Lets say that the source sheet is AUDIO and the target is TEST1. The value that needed to check is range B13:B25
Can this be done with multiple source sheets and multiple source ranges? All will copied to the same target sheet.

I have found some posts in mrexcel but I cant make them to work properly (maybe multiple criteria are wrong)

Can you help?

Thank you in advance!

 

[Joe4]

@Joe4 Hello again.
I need your help if it is possible (and I am asking you because you know the case).
Can I use the Intersection in order to:
Within the source ranges (Union above etc) I need to find out if a cell that is already copied in Proforma, and the cell located to other sheets ranges (audio, lights etc), changed, can be then copied to proforms (entire row or the cell value, and delete the previous one).

Can this be done?
I have tried various examples with Intersection but no luck

Thank you in advance!

That is a whole new twist on the original question.
I recommend posting a new thread on the topic, as I will probably not be able to look into something that complex today.

 

[pantakos]

That is a whole new twist on the original question.
I recommend posting a new thread on the topic, as I will probably not be able to look into something that complex today.

Of cource. I will post a new thread about that. I dont mind if it is for today or some other day.

Thank you !