Closed Thread
Results 1 to 3 of 3

Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values

    I have Unique Data in column A:A in Two Sheet (Sheet1) as CCI & Sheet2 As ONSITE
    I want split data Through End A:A Column From Sheet (CCI & ONSITE)

    Out Put Result I want Splited Data move to new work with creation of names of Partner from column A:A
    In output file also two sheet (CCI&ONSITE)

    I uploaded sheet's (Input & Result Files)Please check if you can help me on this

    Here Input File
    Out File is Aegis Infoware Pvt.ltd.xls = Only contains (CCI&ONSITE) of Aegis Infoware Pvt.ltd partner's A:A column of INput
    Next File is Aim Enterprises.xls = Only contains (CCI&ONSITE) of Aim Enterprises of A:A column of INput
    like that
    all uniques values get split and make sheet name of A:A column value.

    I waiting for ur early reply dude's
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Valu

    Third time duplicate

    http://www.excelforum.com/excel-prog...two-sheet.html

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Valu

    Thanks AB33.

    Excelhooker, i am already working with you on the other thread. Whats the point in duplicating efforts by creating another thread for the same question?

    Thread closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

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