Results 1 to 13 of 13

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

Threaded View

Ricker090 Copy and paste data to... 04-26-2011, 08:36 PM
Leith Ross Re: Copy and paste data to... 04-26-2011, 08:48 PM
Ricker090 Re: Copy and paste data to... 04-26-2011, 08:57 PM
Leith Ross Re: Copy and paste data to... 04-26-2011, 09:11 PM
Ricker090 Re: Copy and paste data to... 04-27-2011, 06:35 AM
Leith Ross Re: Copy and paste data to... 04-27-2011, 12:24 PM
Ricker090 Re: Copy and paste data to... 04-27-2011, 01:50 PM
Ricker090 Re: Copy and paste data to... 04-27-2011, 08:18 PM
Leith Ross Re: Copy and paste data to... 04-27-2011, 08:23 PM
Ricker090 Re: Copy and paste data to... 04-27-2011, 09:49 PM
Leith Ross Re: Copy and paste data to... 04-27-2011, 10:35 PM
Ricker090 Re: Copy and paste data to... 04-28-2011, 04:26 AM
payalpinata Re: Copy and paste data to... 07-13-2011, 02:23 PM
  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