Results 1 to 5 of 5

copy unique value from column to another column

Threaded View

Bax copy unique value from column... 02-19-2015, 12:03 PM
sourabhg98 Re: copy unique value from... 02-19-2015, 12:31 PM
Jakobshavn Re: copy unique value from... 02-19-2015, 12:34 PM
AB33 Re: copy unique value from... 02-19-2015, 04:24 PM
Bax Re: copy unique value from... 02-20-2015, 03:42 AM
  1. #1
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    copy unique value from column to another column

    Hi All,

    Probably a very easy question, but couldn't find a thread similar to this.

    In column A I have weeknumbers (duplicates occur). In column C I want all unique weeknumbers from column A.
    Data in column A starts at cell A6, the blanks are not to be copied. Pasting in cell C2 downward. Column C then to be sorted smallest to largest.

    See attached file with the example data.

    What will need to be the VBA code to obtain the above?

    Thanks all for your input!
    Peter
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count unique occurences in one column with unique occurances in another column
    By 21stCenturyLessons in forum Excel General
    Replies: 5
    Last Post: 07-12-2014, 08:44 AM
  2. [SOLVED] Macro to copy and paste only unique values from one column to another column in same sheet
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2014, 05:44 AM
  3. [SOLVED] How to copy rows to new worksheet based on unique first character in column
    By G-N-A in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2013, 12:43 PM
  4. [SOLVED] Macro to copy unique cells to another column
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2012, 04:36 PM
  5. [SOLVED] Macro to identify a unique value in a column to copy and paste value to another sheet
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2012, 07:59 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