Copy non-Zero columns to new location macro

**Craigm** · 06-16-2005, 01:25 PM

I need a macro to run down a column A and where its value is >0 I need to copy two columns to a new location.

----a----b----c----d
1---6---a
2---0---b
3---4---c

In this case I need to copy "6" to C1 and "a" to D1. Then copy "4" to C2 and "c" to D2. There are up to five hundred rows.

Thanks for helping this thick headed sole.

Craig

**bhofsetz** · 06-16-2005, 01:37 PM

Give this a try

Please Login or Register  to view this content.

Select the range or column you want to operate on and then run the marco.

HTH

**Craigm** · 06-16-2005, 01:44 PM

Thanks for the quick reply.

This does not move the zeros. But it does copy column B to column C in error when a zero is present in column A.

This is very close. If there is a zero in column A I want to skip the whole row.

Thanks for your help.

Craig

**Craigm** · 06-16-2005, 01:50 PM

My Bad, I got the code wrong. This worked perfect! Thanks for the OUTSTANDING help!

**Craigm** · 06-16-2005, 02:12 PM

For the posted code to work Column A must be manually selected.

How do I focus this code on say a range from AC3 to AC75? So that the code will run without having to select the data?

**bhofsetz** · 06-16-2005, 02:31 PM

You can hard code the range to operate on either of these two ways. I'm assuming that you want the results offset by 2 columns into AE and AF. You can modify the destination ranges as needed.

Please Login or Register  to view this content.

Take your pick

HTH

**Craigm** · 06-16-2005, 02:37 PM

Your timely help is amazing. I have struggled with this all day.

Thank YOU!

Copy non-Zero columns to new location macro

LinkBack

Thread Tools

Rate This Thread

Display

Copy non-Zero columns to new location macro

Almost does not move 0 but moves all else

My Bad

Column A Must be Selected

WOW! Thank you!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions