Results 1 to 9 of 9

Copy paste depending on cells property

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2015
    Location
    france
    MS-Off Ver
    2010
    Posts
    57

    Copy paste depending on cells property

    Hi everyone,

    I would need some help with the following macro (module 15 in file attached).

    The codes already written alows me to move from one cell to another to the right (2 cells to the right), within the chart.

    The goal would be when the selected cell comes accross a "0" (for instance on cell M28), it copies paste it on cell+2 (to the right) in AM29.
    And when it comes across a red interior cell (AK29 for instance) it copies it on cell+2 (to the right), in I26


    Thanks again for your help
    (cannot attached file for some reason, will try later on)


    Sub split()
    
    
        For Each rw In Range("D14:AZ76").Rows
            If Cells(rw.Row, "B").Value >= Date Then
                For Each cll In Intersect(rw, Range("E:E,G:G,I:I,K:K,M:M,O:O,Q:Q,S:S,U:U,W:W,Y:Y,AA:AA,AC:AC,AE:AE,AG:AG,AI:AI,AK:AK,AM:AM,AO:AO,AQ:AQ,AS:AS,AU:AU,AW:AW,AY:AY")).Cells
                    If Application.Count(cll.Offset(, -1)) = 1 Then
                        cll.Select
                        
                     
                         End If
                    cll.Select
    
    
          
                   Next cll
              End If
              Next rw
              
    End Sub
    Last edited by ced0802; 04-09-2016 at 12:18 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy and Paste in different locations depending on adjacent cell value
    By ScabbyDog in forum Excel General
    Replies: 19
    Last Post: 01-23-2016, 02:17 PM
  2. copy & paste to other sheets depending on dates specified in cells
    By ufopilot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2015, 05:43 AM
  3. Copy range and paste depending on the selected checkbox
    By mackypogi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2014, 10:38 PM
  4. Copy and paste from one worksheet to another depending on date
    By darrenb78 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-04-2013, 01:31 PM
  5. [SOLVED] Copy paste depending on certain criteria (VBA)
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2012, 07:59 AM
  6. Copy and Paste macro depending on a cell
    By john_london in forum Excel General
    Replies: 4
    Last Post: 11-08-2010, 11:05 AM
  7. Copy and Paste Depending on Cell
    By Craig2097 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2010, 11:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1