Results 1 to 13 of 13

Copy and paste data to separate sheets based on mutiple criteria again

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    157

    Copy and paste data to separate sheets based on mutiple criteria again

    I had a problem solved for me previously here. However, I now have additional data that needs to be copied over to a new sheet. This data includes blank cells.

    I embedded an If statement to help fix the issue, but it doesn't seem to work.

    For Each iCell In wsData.Range("A" & CurrentItem & ":L" & CurrentItem)
        Dim rngNextLine As Range:   Set rngNextLine = wsDest.Cells(Rows.Count, iCell.Column).End(xlUp).Offset(1, 0)
            If iCell.Value = "" Then
            rngNextLine.Value = ""
            Else
            rngNextLine.Value = iCell.Value
            End If
    Next iCell
    Can anyone tell me what I'm doing wrong? I've attached my sample.
    Attached Files Attached Files
    Last edited by Ricker090; 04-27-2011 at 01:50 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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