+ Reply to Thread
Results 1 to 3 of 3

Copy unique values from new data and append to existing list in another worksheet

  1. #1
    Registered User
    Join Date
    11-04-2021
    Location
    London
    MS-Off Ver
    2019
    Posts
    3

    Copy unique values from new data and append to existing list in another worksheet

    Hi,

    Please find attached an example of what i'm trying to achieve...

    Basically I load data into the data tab, which will have more rows of data - what i'd like to do is filter by unique values based on the list within the Unique_Values list then copy and paste those values into the unique values list



    Hopefully the attached explains it better.

    Thanks in advance

    Colin
    Attached Files Attached Files
    Last edited by colin_dickson; 01-07-2022 at 06:35 AM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Copy unique values from new data and append to existing list in another worksheet

    Hello, and welcome to the forum.

    I believe Excel 2019 has the various new functions now in 365.

    In which case just put the following in A1 (or wherever) on the Unique sheet.

    =UNIQUE(Data!A:A)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Copy unique values from new data and append to existing list in another worksheet

    Hi Colin

    Welcome to the forum...
    Please Login or Register  to view this content.
    oR

    Please Login or Register  to view this content.
    Last edited by sintek; 01-07-2022 at 07:22 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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] copy and transpose two arrays to new worksheet and append to existing data
    By Nerpilis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2017, 09:11 PM
  2. [SOLVED] Loop through list of unique values to copy & transpose data
    By YOO629 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2015, 04:34 PM
  3. Replies: 11
    Last Post: 11-04-2013, 04:32 PM
  4. Replies: 3
    Last Post: 10-14-2013, 03:06 PM
  5. Create list of Unique values based on Worksheet Data
    By todmac in forum Excel General
    Replies: 3
    Last Post: 02-09-2012, 08:17 PM
  6. Append columns to existing worksheet?
    By Chris Burnette in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2005, 06:17 PM
  7. append Data into an existing worksheet
    By Naresh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2005, 03:36 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