+ Reply to Thread
Results 1 to 2 of 2

Copy Non-BlankValues of 3 Worksheets and Paste Unique Values

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-08-2012
    Location
    San Clemente, California
    MS-Off Ver
    Office365
    Posts
    383

    Copy Non-BlankValues of 3 Worksheets and Paste Unique Values

    Within the same workbook three worksheets all have the same column of information. All three worksheets have many more blanks than data. I need to copy the non-blank values of all three and then paste only the non-duplicated values into sheet 4. Example:

    Sheet1 - input 1
    A
    blank
    B
    C

    Sheet2 - input 2
    B
    blank
    blank
    C
    D

    Sheet3 - input 3
    F
    blank
    blank
    A
    B

    Sheet4 - result, sorted copy of one and only one instance of all the values on sheets 1, 2 and 3, without blanks
    A
    B
    C
    D
    F

    Thanks in advance for your help!

  2. #2
    Forum Contributor
    Join Date
    10-08-2012
    Location
    San Clemente, California
    MS-Off Ver
    Office365
    Posts
    383

    Re: Copy Non-BlankValues of 3 Worksheets and Paste Unique Values

    OOPS. I made a mistake in my setup. Kindly disregard this request. I will create a new thread. My apology for the bother.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Dynamic way to copy and paste unique values
    By Joakim1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-07-2014, 07:31 AM
  2. Unique Copy and Paste Macro - Multiple Worksheets Based on IF (AND) criteria
    By dwalt75 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-16-2013, 04:49 PM
  3. Copy & Paste Unique Values
    By boiler2003 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2012, 09:08 AM
  4. Copy and paste unique values to another worksheet
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2009, 11:44 AM
  5. Copy & Paste Unique Cells Values
    By Michael168 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2005, 07:14 AM

Tags for this Thread

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