Select every field in row different from value and copy

J

jebenexcel

Board Regular
Joined
Mar 16, 2018
Messages
59
Hello guys,

I'd like to make a macro that selects all values in column J that are different from 0, and all values in column K different from 0.01.1900, and copies them on let's say A1 on sheet2. The dimensions of the J and K values will match and will be in one block.
Any help?
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
You must log in or register to reply here.

Similar threads

I
  • Question Question
Filter column on text value if that value exists using VBA
Replies
7
Views
411
Peter_SSs
Peter_SSs
A
  • Solved
copy specific columns from listbox to userform without selection
2 3
Replies
21
Views
302
MikeVol
MikeVol
L
  • Solved
copy cell and cell above onto different sheet, under the next available line.
Replies
5
Views
207
Alex Blakenburg
A
S
  • Solved
Copy Textbox values from UserForm to the worksheet
Replies
6
Views
327
AlphaFrog
AlphaFrog
N
  • Question Question
How can I sort rows into different worksheets?
Replies
2
Views
143
nithchun
N

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

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
Back
Top