Results 1 to 4 of 4

vba split data as per column unique values and move to exact workbook into sht(opencall)

Threaded View

breadwinner vba split data as per column... 01-23-2014, 03:29 AM
JBeaucaire Re: vba split data as per... 01-23-2014, 03:40 AM
breadwinner Re: vba split data as per... 01-23-2014, 11:10 PM
JBeaucaire Re: vba split data as per... 01-23-2014, 11:29 PM
  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    vba split data as per column unique values and move to exact workbook into sht(opencall)

    Dear Vba Experts

    I am need of vba code to copy data from master workbook sheet to particular named workbook sheet, based on unique values

    i have list of partner name repeat multiple times in master file and i kept 57 partner named workbook in the sheet of opencall in path location,
    ("D:\Documents and Settings\Administrator\Desktop\xxx\all 57 files")

    if i click the macro need to split data Ageis Infoware partner based on unique values with range a:d move to Aegisinfoware file (sheet is "Opencall") there need to be stored automatically

    find the attachment first is master and 2 files stored in path location ....two file result after task completion
    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] VBA to data Split from column values as new workbook save into folder with dashboard sheet
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-08-2014, 02:03 AM
  2. VBA to split column values as new workbook along with hidding sheets
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2013, 08:16 AM
  3. [SOLVED] Split and send data per unique value in a column
    By Tino XXL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2013, 04:32 AM
  4. Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 04:21 AM
  5. Split Rows For Unique Values In A Column To Different Workbooks
    By ashishmac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-22-2013, 02:45 PM

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