Copy entire row if cell is not empty - VBA

pantakos

Board Regular
Joined
Oct 10, 2012
Messages
88
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,950
Office Version
  1. 365
Platform
  1. Windows
@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.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

pantakos

Board Regular
Joined
Oct 10, 2012
Messages
88
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 !
 

Forum statistics

Threads
1,141,058
Messages
5,704,031
Members
421,323
Latest member
Exidous

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top