Results 1 to 6 of 6

Need to copy store names from sheet1 to sheet3 and remove duplicate names

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-15-2014
    Location
    london
    MS-Off Ver
    2013
    Posts
    111

    Need to copy store names from sheet1 to sheet3 and remove duplicate names

    Hi,

    I have attached the file with three sheets and here is what I need to do using macro.

    Sheet1 has list store names in column "B" starting from row2
    similarly sheet2 has list store names in column "A" starting from row4

    Now I would like to first copy list of all store names from sheet1 to sheet3 column "A" and then would like to append store names from sheet2 to sheet3 column "A".
    Once all names are captured in column "A" sheet3, duplicate store names should be removed from sheet3 so that only unique names are available....

    Please help me with macro code for the same.

    Thank you in advance.
    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. Replies: 1
    Last Post: 10-06-2014, 09:44 AM
  2. [SOLVED] Copy colors / names from Sheet2 to Sheet1
    By Berna11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2013, 10:58 AM
  3. Replies: 5
    Last Post: 08-29-2012, 03:08 AM
  4. Matching names from sheet2, sheet3, sheet4 with names in sheet1
    By Lynx2x in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-28-2012, 07:51 AM
  5. List Names on sheet2 ,but only names used in sheet1
    By 2Raw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2005, 12:10 PM

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