Need copy the column d instead of column b, macro working fine for column b

**audax48** · 05-20-2012, 02:46 PM

This macro is working fine, copying Column B if Column A is April and Column B<>0...I need some adjustments change Column B for D..... if column A is April and Column D <>0 then copy D...tried to change offset(,1) to offset(,3) didn't work...any ideas?

Please Login or Register  to view this content.

Thank you

**zbor** · 05-20-2012, 02:47 PM

Hi audax, please read Forum rules:

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window ... and appear like this when posted:

Please Login or Register  to view this content.

**zbor** · 05-20-2012, 03:01 PM

Hmm.. I think it should work.. Did you change ,1 to ,3 in both parts?

**audax48** · 05-20-2012, 03:12 PM

thank you....if you say both parts of the offset...the second offset work fine copy in W2 column D but doesn't get the info from the first offset copy something else i don't know why