Results 1 to 14 of 14

need help on vba code which work corresponding files depends upon file name

Threaded View

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

    need help on vba code which work corresponding files depends upon file name

    Dear expert

    i have set of data range in master A:H i want split value in a col combination of hypen values to closed workbooks of A,B,C,D,....Etc depends upon list of filenames in col H:H.

    like if file name is A.xlsb in H col this code run to particular row to A workbook
    For Each cell In Sheets("Master").Range("A2:A200") *need to change master sheet as active workbook
    
          If InStr(cell, "-451414-") Then Sheets("RECK").Cells(65000, "E").End(xlUp).Offset(1).Resize(, 12) = Application.Index(Split(Join(Array(Replace$(Replace$(cell, "-0-", "-000000-"), "-", "|"), "00000000", "000", "MAY-15", "USD", "AMOUNT", cell.Offset(, 3), "NO"), "|"), "|"), Array(1, 3, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12))
      Next cell
    End With
    Find the attachment.
    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. need vba code to split rows to closed wb shets depends company code met with sht name
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2016, 12:44 PM
  2. VBA code to insert data from multiple .txt files into one output file template file
    By psmith33 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2015, 02:49 PM
  3. [SOLVED] VBA code to open many files, copy text, close file, paste text in second work
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-11-2014, 12:59 PM
  4. Replies: 2
    Last Post: 02-10-2014, 11:52 AM
  5. [SOLVED] Modify code to work with xls and xlsx files
    By CJ-22 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2013, 11:21 AM
  6. VBa code to open files from two different folders and work on them simultaneously
    By rumshar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 09:41 AM
  7. Update Code to work between 2 files
    By dkenebre in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2005, 10:34 AM

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